Consfued on how to handle memoey issue

Okay here is the question for all of brilliant guys. I have a server
loaded with windows 2003 Enterprise Edition with SP2 on it. I've 2
instanaces on sql 2000 sp3a running on them currently memory for the
box is 8 GB. Now the problem is, one of the instance is of ecommerce
database and that database is massive around 800-900 GB. currently,
it's running under memory pressure i mean sql server process is taking
around 1.8 GB but it's not going beyond that I know it's a problem
with 32-bit edition but we can't move our stuff to 64-bit right away.
I would like to know best way to tackle this problem. I mean what i
have to do to give in order to use more memory. Do i need to enable
AWE on both the instance and use /PAE switch or go beyond that and
use /3GB switch in boot.ini. Let me know.
Thanks,Hi
Which edition of SQL 2000 is this?
You can configure the maximum memory to use with sp_configure 'max server
memory' You can set values for each instance so they add up to 5 GB.
Have you enabled AWE on each instance.
John
"kulkarni.ninad@.gmail.com" wrote:
> Okay here is the question for all of brilliant guys. I have a server
> loaded with windows 2003 Enterprise Edition with SP2 on it. I've 2
> instanaces on sql 2000 sp3a running on them currently memory for the
> box is 8 GB. Now the problem is, one of the instance is of ecommerce
> database and that database is massive around 800-900 GB. currently,
> it's running under memory pressure i mean sql server process is taking
> around 1.8 GB but it's not going beyond that I know it's a problem
> with 32-bit edition but we can't move our stuff to 64-bit right away.
> I would like to know best way to tackle this problem. I mean what i
> have to do to give in order to use more memory. Do i need to enable
> AWE on both the instance and use /PAE switch or go beyond that and
> use /3GB switch in boot.ini. Let me know.
> Thanks,
>|||On Sep 27, 12:54 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi
> Which edition of SQL 2000 is this?
> You can configure the maximum memory to use with sp_configure 'max server
> memory' You can set values for each instance so they add up to 5 GB.
> Have you enabled AWE on each instance.
> John
>
> "kulkarni.ni...@.gmail.com" wrote:
> > Okay here is the question for all of brilliant guys. I have a server
> > loaded with windows 2003 Enterprise Edition with SP2 on it. I've 2
> > instanaces on sql 2000 sp3a running on them currently memory for the
> > box is 8 GB. Now the problem is, one of the instance is of ecommerce
> > database and that database is massive around 800-900 GB. currently,
> > it's running under memory pressure i mean sql server process is taking
> > around 1.8 GB but it's not going beyond that I know it's a problem
> > with 32-bit edition but we can't move our stuff to 64-bit right away.
> > I would like to know best way to tackle this problem. I mean what i
> > have to do to give in order to use more memory. Do i need to enable
> > AWE on both the instance and use /PAE switch or go beyond that and
> > use /3GB switch in boot.ini. Let me know.
> > Thanks,- Hide quoted text -
> - Show quoted text -
No we haven't enabled AWE actually and that's where I'm confused at
because in past, I have enabled AWE for single instance but haven't
done it for multiple instances.
Will it work if I enable AWE on both the instance of sql server? and
BTW, sql edition is Enterprise Edition.
Thanks,|||Hi
You should be able to enable AWE for both instances, but even if you enable
it for only one instance you should set the maximum memory for that instance
to avoid it grabbing all the memory.
John
"kulkarni.ninad@.gmail.com" wrote:
> On Sep 27, 12:54 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> > Hi
> >
> > Which edition of SQL 2000 is this?
> >
> > You can configure the maximum memory to use with sp_configure 'max server
> > memory' You can set values for each instance so they add up to 5 GB.
> > Have you enabled AWE on each instance.
> >
> > John
> >
> >
> >
> > "kulkarni.ni...@.gmail.com" wrote:
> > > Okay here is the question for all of brilliant guys. I have a server
> > > loaded with windows 2003 Enterprise Edition with SP2 on it. I've 2
> > > instanaces on sql 2000 sp3a running on them currently memory for the
> > > box is 8 GB. Now the problem is, one of the instance is of ecommerce
> > > database and that database is massive around 800-900 GB. currently,
> > > it's running under memory pressure i mean sql server process is taking
> > > around 1.8 GB but it's not going beyond that I know it's a problem
> > > with 32-bit edition but we can't move our stuff to 64-bit right away.
> > > I would like to know best way to tackle this problem. I mean what i
> > > have to do to give in order to use more memory. Do i need to enable
> > > AWE on both the instance and use /PAE switch or go beyond that and
> > > use /3GB switch in boot.ini. Let me know.
> >
> > > Thanks,- Hide quoted text -
> >
> > - Show quoted text -
> No we haven't enabled AWE actually and that's where I'm confused at
> because in past, I have enabled AWE for single instance but haven't
> done it for multiple instances.
> Will it work if I enable AWE on both the instance of sql server? and
> BTW, sql edition is Enterprise Edition.
> Thanks,
>|||You do not need to add /3GB switch to the boot.ini file; however, you need
to add /PAE to be able to use 6GB of RAM over 8GB. Only enabling AWE won't
let you use 6GB of RAM. (You can use 6GB because Kernel Components and
Operating System use 2GB of RAM) And this process (enabling AWE and PAE)
needs a reboot of your server.
--
Ekrem Önsoy
<kulkarni.ninad@.gmail.com> wrote in message
news:1190914211.251116.224130@.57g2000hsv.googlegroups.com...
> On Sep 27, 12:54 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
>> Hi
>> Which edition of SQL 2000 is this?
>> You can configure the maximum memory to use with sp_configure 'max server
>> memory' You can set values for each instance so they add up to 5 GB.
>> Have you enabled AWE on each instance.
>> John
>>
>> "kulkarni.ni...@.gmail.com" wrote:
>> > Okay here is the question for all of brilliant guys. I have a server
>> > loaded with windows 2003 Enterprise Edition with SP2 on it. I've 2
>> > instanaces on sql 2000 sp3a running on them currently memory for the
>> > box is 8 GB. Now the problem is, one of the instance is of ecommerce
>> > database and that database is massive around 800-900 GB. currently,
>> > it's running under memory pressure i mean sql server process is taking
>> > around 1.8 GB but it's not going beyond that I know it's a problem
>> > with 32-bit edition but we can't move our stuff to 64-bit right away.
>> > I would like to know best way to tackle this problem. I mean what i
>> > have to do to give in order to use more memory. Do i need to enable
>> > AWE on both the instance and use /PAE switch or go beyond that and
>> > use /3GB switch in boot.ini. Let me know.
>> > Thanks,- Hide quoted text -
>> - Show quoted text -
> No we haven't enabled AWE actually and that's where I'm confused at
> because in past, I have enabled AWE for single instance but haven't
> done it for multiple instances.
> Will it work if I enable AWE on both the instance of sql server? and
> BTW, sql edition is Enterprise Edition.
> Thanks,
>|||Hi
See http://www.sql-server-performance.com/tips/awe_memory_p1.aspx
John
"Ekrem Ã?nsoy" wrote:
> You do not need to add /3GB switch to the boot.ini file; however, you need
> to add /PAE to be able to use 6GB of RAM over 8GB. Only enabling AWE won't
> let you use 6GB of RAM. (You can use 6GB because Kernel Components and
> Operating System use 2GB of RAM) And this process (enabling AWE and PAE)
> needs a reboot of your server.
> --
> Ekrem nsoy
>
>
> <kulkarni.ninad@.gmail.com> wrote in message
> news:1190914211.251116.224130@.57g2000hsv.googlegroups.com...
> > On Sep 27, 12:54 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> >> Hi
> >>
> >> Which edition of SQL 2000 is this?
> >>
> >> You can configure the maximum memory to use with sp_configure 'max server
> >> memory' You can set values for each instance so they add up to 5 GB.
> >> Have you enabled AWE on each instance.
> >>
> >> John
> >>
> >>
> >>
> >> "kulkarni.ni...@.gmail.com" wrote:
> >> > Okay here is the question for all of brilliant guys. I have a server
> >> > loaded with windows 2003 Enterprise Edition with SP2 on it. I've 2
> >> > instanaces on sql 2000 sp3a running on them currently memory for the
> >> > box is 8 GB. Now the problem is, one of the instance is of ecommerce
> >> > database and that database is massive around 800-900 GB. currently,
> >> > it's running under memory pressure i mean sql server process is taking
> >> > around 1.8 GB but it's not going beyond that I know it's a problem
> >> > with 32-bit edition but we can't move our stuff to 64-bit right away.
> >> > I would like to know best way to tackle this problem. I mean what i
> >> > have to do to give in order to use more memory. Do i need to enable
> >> > AWE on both the instance and use /PAE switch or go beyond that and
> >> > use /3GB switch in boot.ini. Let me know.
> >>
> >> > Thanks,- Hide quoted text -
> >>
> >> - Show quoted text -
> >
> > No we haven't enabled AWE actually and that's where I'm confused at
> > because in past, I have enabled AWE for single instance but haven't
> > done it for multiple instances.
> > Will it work if I enable AWE on both the instance of sql server? and
> > BTW, sql edition is Enterprise Edition.
> >
> > Thanks,
> >
>|||Well, I'm not really sure of using /3GB all the time at least if it's really
unnecessary. I would not use it unless I really need that 1GB of RAM.
--
Ekrem Ã?nsoy
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:D2EE787C-CC99-4F84-8872-09B30278CD6A@.microsoft.com...
> Hi
> See http://www.sql-server-performance.com/tips/awe_memory_p1.aspx
> John
> "Ekrem Ã?nsoy" wrote:
>> You do not need to add /3GB switch to the boot.ini file; however, you
>> need
>> to add /PAE to be able to use 6GB of RAM over 8GB. Only enabling AWE
>> won't
>> let you use 6GB of RAM. (You can use 6GB because Kernel Components and
>> Operating System use 2GB of RAM) And this process (enabling AWE and PAE)
>> needs a reboot of your server.
>> --
>> Ekrem nsoy
>>
>>
>> <kulkarni.ninad@.gmail.com> wrote in message
>> news:1190914211.251116.224130@.57g2000hsv.googlegroups.com...
>> > On Sep 27, 12:54 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
>> >> Hi
>> >>
>> >> Which edition of SQL 2000 is this?
>> >>
>> >> You can configure the maximum memory to use with sp_configure 'max
>> >> server
>> >> memory' You can set values for each instance so they add up to 5 GB.
>> >> Have you enabled AWE on each instance.
>> >>
>> >> John
>> >>
>> >>
>> >>
>> >> "kulkarni.ni...@.gmail.com" wrote:
>> >> > Okay here is the question for all of brilliant guys. I have a server
>> >> > loaded with windows 2003 Enterprise Edition with SP2 on it. I've 2
>> >> > instanaces on sql 2000 sp3a running on them currently memory for the
>> >> > box is 8 GB. Now the problem is, one of the instance is of ecommerce
>> >> > database and that database is massive around 800-900 GB. currently,
>> >> > it's running under memory pressure i mean sql server process is
>> >> > taking
>> >> > around 1.8 GB but it's not going beyond that I know it's a problem
>> >> > with 32-bit edition but we can't move our stuff to 64-bit right
>> >> > away.
>> >> > I would like to know best way to tackle this problem. I mean what i
>> >> > have to do to give in order to use more memory. Do i need to enable
>> >> > AWE on both the instance and use /PAE switch or go beyond that and
>> >> > use /3GB switch in boot.ini. Let me know.
>> >>
>> >> > Thanks,- Hide quoted text -
>> >>
>> >> - Show quoted text -
>> >
>> > No we haven't enabled AWE actually and that's where I'm confused at
>> > because in past, I have enabled AWE for single instance but haven't
>> > done it for multiple instances.
>> > Will it work if I enable AWE on both the instance of sql server? and
>> > BTW, sql edition is Enterprise Edition.
>> >
>> > Thanks,
>> >|||Hi
There should not be an issue using it as there is only a limited amount of
memory in the server. If the OP is seeing memory presure once AWE has been
enabled, then it is certainly something he should be doing.
John
"Ekrem Ã?nsoy" wrote:
> Well, I'm not really sure of using /3GB all the time at least if it's really
> unnecessary. I would not use it unless I really need that 1GB of RAM.
> --
> Ekrem Ã?nsoy
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:D2EE787C-CC99-4F84-8872-09B30278CD6A@.microsoft.com...
> > Hi
> >
> > See http://www.sql-server-performance.com/tips/awe_memory_p1.aspx
> >
> > John
> >
> > "Ekrem Ã?nsoy" wrote:
> >
> >> You do not need to add /3GB switch to the boot.ini file; however, you
> >> need
> >> to add /PAE to be able to use 6GB of RAM over 8GB. Only enabling AWE
> >> won't
> >> let you use 6GB of RAM. (You can use 6GB because Kernel Components and
> >> Operating System use 2GB of RAM) And this process (enabling AWE and PAE)
> >> needs a reboot of your server.
> >>
> >> --
> >> Ekrem nsoy
> >>
> >>
> >>
> >>
> >> <kulkarni.ninad@.gmail.com> wrote in message
> >> news:1190914211.251116.224130@.57g2000hsv.googlegroups.com...
> >> > On Sep 27, 12:54 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> >> >> Hi
> >> >>
> >> >> Which edition of SQL 2000 is this?
> >> >>
> >> >> You can configure the maximum memory to use with sp_configure 'max
> >> >> server
> >> >> memory' You can set values for each instance so they add up to 5 GB.
> >> >> Have you enabled AWE on each instance.
> >> >>
> >> >> John
> >> >>
> >> >>
> >> >>
> >> >> "kulkarni.ni...@.gmail.com" wrote:
> >> >> > Okay here is the question for all of brilliant guys. I have a server
> >> >> > loaded with windows 2003 Enterprise Edition with SP2 on it. I've 2
> >> >> > instanaces on sql 2000 sp3a running on them currently memory for the
> >> >> > box is 8 GB. Now the problem is, one of the instance is of ecommerce
> >> >> > database and that database is massive around 800-900 GB. currently,
> >> >> > it's running under memory pressure i mean sql server process is
> >> >> > taking
> >> >> > around 1.8 GB but it's not going beyond that I know it's a problem
> >> >> > with 32-bit edition but we can't move our stuff to 64-bit right
> >> >> > away.
> >> >> > I would like to know best way to tackle this problem. I mean what i
> >> >> > have to do to give in order to use more memory. Do i need to enable
> >> >> > AWE on both the instance and use /PAE switch or go beyond that and
> >> >> > use /3GB switch in boot.ini. Let me know.
> >> >>
> >> >> > Thanks,- Hide quoted text -
> >> >>
> >> >> - Show quoted text -
> >> >
> >> > No we haven't enabled AWE actually and that's where I'm confused at
> >> > because in past, I have enabled AWE for single instance but haven't
> >> > done it for multiple instances.
> >> > Will it work if I enable AWE on both the instance of sql server? and
> >> > BTW, sql edition is Enterprise Edition.
> >> >
> >> > Thanks,
> >> >
> >>
>

Connectivity issues

Hi,

I get the following error message trying to connect locally to sql server 2005 dev edition on xp sp2 machine.

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)

I have enabled all protocols , the sql browser is running , sql agent and sql database engine not running. All other services like reporting etc are running.

The server is set up to run under local system account. Logging in as administrator, .

This server is installed as default instance . ( I do have sql exp and sql server 200 dev edition installed as named instances)

Beginning to pull my hair out.

Any help would be greatly appreciated.

Regards,

Well, you said the database engine is NOT running? From the looks of things that's what you're trying to connect to...I'll assume a typo maybe? The DB Engine service must be running if you're trying to connect to the SQL engine...

|||

Thank you Chad for the illuminating response.

The problem is precisely that the database engine will not start , I understand that the engine must running order for me to connect to a database , however I have made no mention of trying to connect to a database.

If you have any helpful suggestions I would really appreciate it.

Thank you

Andy

|||

Hi Andy...honestly, everything you wrote in your initial posting was indicating that you were having trouble trying to connect to the server...per your initial post:

"I get the following error message trying to connect locally to sql server 2005 dev edition on xp sp2 machine."

Then, the error message you posted indicates that you are indeed trying to connect to the server from an application:

"An error has occurred while establishing a connection to the server...."

And, it even describes a connection level provider (named pipes)...

So, given your original posting, it seems you are having trouble connecting to the instance, not getting it running. Myself and others would be more than happy to help you debug why you are having trouble getting the engine to start, but we'd need entirely different information.

If you'd like help with why the engine is not able to start, please post any error messages you notice in the application log, sql server error log, and system log related to the SQL Server instance, that's what we'd need to see to help you understand why the engine will not start.

On a final note, bear in mind that folks on the forums are trying to help you, not trying to insult you, and you'll always get more help if you treat myself and others with respect, not by being smart with us. You may notice that I am an administrator of these SQL forums, so please keep posts as civil as possible.

Regards

|||

HI Chad,

My apologies for coming across so curt , having re-read my response it does seem as though I was being rude , not my intention. Perhaps a bit of frustration creeping in, the problem is that my vocabulary and knowledge is lacking and expressing myself in a meaningful way is difficult and perhaps to some one with your knowledge, confusing.

If I am getting an error as described above when trying to get an instance started (i.e. the error is generated when I try and get the engine started) through Management Studio then I assume that error is relevant and that is what I will report on. Having read your second post it is now obvious that the error describes a connection problem rather than an issue regarding the instance running.( which obviously is as result of the engine not running.)

I checked the error log and found a network error which I googled , it seems as though if the via protocol is the culprit , having disabled this protocol the engine started .

The network error in the log:

TDSSNIClient initialization failed with error 0x7e, status code 0x60.

Thank you and my apologies once again.

|||

No worries, I definately understand frustation, we're all quite accustomed to that unfortunately. Glad you were able to get things working,

Regards,

sqlsql

Connectivity issue with SQL 2005 Developer Edition Named Instance

Hi,

I have installed one default and one named instance of SQL Server 2005 Dev. Editition SP2 on my server.

The Named service is configured to use Shared, NamedPipe and TCP (Port 4333).

There is no firewall on the machine. But still i am not able to connect to it form remote computer.

can any one help me with these. this is urgent.

Thanks.

KV

I found it. My SQL Browser service was running under domain account which was not working, i have configured it to run under NetworkService and it has started. sqlsql

Connectivity error on a table

I am using sgl2000 server ent. edition. I could not view the table on a
database.I am able to view the structure of the same. When I try to run a
query with the same table it says an error "[Microsoft][ODBC SQL Ser
ver
Driver]& #91;DBNETLIB]ConnectionOpen(WrapperRead(
))"
I don't know what is to be done? But last one year i am using the same table
without any issues. please any one could resolve this issue.Hi
Check the SQL Event log.
You might get a surprise and find that SQL has killed your SPID due to
corruption on that table.
Regards
Mike
"Shanthi" wrote:

> I am using sgl2000 server ent. edition. I could not view the table on a
> database.I am able to view the structure of the same. When I try to run a
> query with the same table it says an error "[Microsoft][ODBC SQL S
erver
> Driver]& #91;DBNETLIB]ConnectionOpen(WrapperRead(
))"
> I don't know what is to be done? But last one year i am using the same tab
le
> without any issues. please any one could resolve this issue.|||I have checked both sql log and event log and nothing found as you told.
Please let me know if any thing is to be done.
Shanthi
"Mike Epprecht (SQL MVP)" ?? ????:
[vbcol=seagreen]
> Hi
> Check the SQL Event log.
> You might get a surprise and find that SQL has killed your SPID due to
> corruption on that table.
> Regards
> Mike
> "Shanthi" wrote:
>

Connectivity error on a table

I am using sgl2000 server ent. edition. I could not view the table on a
database.I am able to view the structure of the same. When I try to run a
query with the same table it says an error "[Microsoft][ODBC SQL Server
Driver][DBNETLIB]ConnectionOpen(WrapperRead())"
I don't know what is to be done? But last one year i am using the same table
without any issues. please any one could resolve this issue.
Hi
Check the SQL Event log.
You might get a surprise and find that SQL has killed your SPID due to
corruption on that table.
Regards
Mike
"Shanthi" wrote:

> I am using sgl2000 server ent. edition. I could not view the table on a
> database.I am able to view the structure of the same. When I try to run a
> query with the same table it says an error "[Microsoft][ODBC SQL Server
> Driver][DBNETLIB]ConnectionOpen(WrapperRead())"
> I don't know what is to be done? But last one year i am using the same table
> without any issues. please any one could resolve this issue.
|||I have checked both sql log and event log and nothing found as you told.
Please let me know if any thing is to be done.
Shanthi
"Mike Epprecht (SQL MVP)" ?? ????:
[vbcol=seagreen]
> Hi
> Check the SQL Event log.
> You might get a surprise and find that SQL has killed your SPID due to
> corruption on that table.
> Regards
> Mike
> "Shanthi" wrote:

Connectionstring

Im using sql server express advanced edition and Windows Vista. My Windows
account doesnt have any permissions to the sql server at all, so I need to
use sql server logins in my connectionstring. How can I provide that when
using attachdb?
This is my connectionstring today:
Data Source=. \SQLEXPRESS;AttachDbFilename=|DataDirect
ory|\site_db.mdf;User
Instance=False;Initial Catalog=site_db;
StigSee http://www.microsoft.com/sql/howtob...stasupport.mspx for
considerations on using SQL 2005 under Vista. Note that SP2 is still in CTP
(beta).
I haven't played around with SQL Express but you ought to be able to add the
desired SQL login credentials in the connection string:
Data Source=. \SQLEXPRESS;AttachDbFilename=|DataDirect
ory|\site_db.mdf;User
Instance=False;Initial Catalog=site_db;User Id=MyLogin;Password=MyPassword
Hope this helps.
Dan Guzman
SQL Server MVP
"Stig Kulvedrsten" <stig@.spire.as> wrote in message
news:0ABA74C2-E6C4-4E84-B331-3633D0BEC597@.microsoft.com...
> Im using sql server express advanced edition and Windows Vista. My Windows
> account doesnt have any permissions to the sql server at all, so I need to
> use sql server logins in my connectionstring. How can I provide that when
> using attachdb?
> This is my connectionstring today:
> Stig|||I reinstalled and got my sql server express up and running. I then loaded up
VS.NET and tried to run my website.
Right away I got this error:
Timeout expired. The timeout period elapsed prior to obtaining a connection
from the pool. This may have occurred because all pooled connections were
in use and max pool size was reached.
What causes this error at first runtime?
Stig
"Stig Kulvedrsten" <stig@.spire.as> wrote in message
news:0ABA74C2-E6C4-4E84-B331-3633D0BEC597@.microsoft.com...
> Im using sql server express advanced edition and Windows Vista. My Windows
> account doesnt have any permissions to the sql server at all, so I need to
> use sql server logins in my connectionstring. How can I provide that when
> using attachdb?
> This is my connectionstring today:
> Data Source=. \SQLEXPRESS;AttachDbFilename=|DataDirect
ory|\site_db.mdf;User
> Instance=False;Initial Catalog=site_db;
> Stig

Connection woos

Just the other day I have not been able to connect to SQL Server 2005 Express Edition. NOTHING has changed. All I have noticed is that in the Surface Area Configurator the Local Connections only radio button it selected. So I try selecting the Remote radio button and Apply and Ok and then exit the Surface Area Configurator program and then come back in again and the Local Only is selected.

Is this normal behavior? Is Remote connections allowed or not? How verify?

Thanks.

hi,

do you mean you set the "Allow remote connections" setting and suddenly (the other day) it turned it OFF by magic? and since then (the other day) you are no longer able to enable "remote connections"?

please verify via the SQL Server Configuration Manager you do have a network protocol enabled, restart the SQL Server engine service and, via SAC check remote connections are enabled..

regards

|||

TCP/IP and Shared memory are enabled, and the engine and browser are running.

Remote connections where working, so yes the other day all stopped!

When I start up SAC the Local Only radio button is enabled. So I enabled remote and applied and ok'd.

Come back into SAC again and the Local Only radio button is enabled.

Is this proper behavior, meaning the program never saves the setting?

|||

hi,

Expressman wrote:

Is this proper behavior, meaning the program never saves the setting?

actually not.. did you try restarting the service?

regards

|||

Yes I restart the engine and browser!

I wonder if there could be a virus or hack out now doing it?!

When installing 2005 Express Edition does it associate the
ip address with the database even though ya used a name?

|||

I installed the MS SSEUtil program.

'sseutil - listsrv' command *without quotes' doesn't show any server running. lolol

Yet my program can access the database using the 'computername and instance name'.

Any ideas?

Could a system service not be running?

|||

hi,

Expressman wrote:

I installed the MS SSEUtil program.

'sseutil - listsrv' command *without quotes' doesn't show any server running. lolol

Yet my program can access the database using the 'computername and instance name'.

Any ideas?

Could a system service not be running?

you are probably using a "User Instance"... User Instances do not allow remote connections..

have a look at http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp for further info about this feature..

regards

|||

My new and my old applications used to work remotely without problems.
Both could connect using the server name or ip address.

Now neither one works now, meaning they can't connect.
Message is that the server doesn't exist.

I can only connect using the server name now, NOT the ip address.

I even tried connection with fire wall off. Buggers!

|||

Well I re-installed the database and all works. Thanks to all helping.

Connection woos

Just the other day I have not been able to connect to SQL Server 2005 Express Edition. NOTHING has changed. All I have noticed is that in the Surface Area Configurator the Local Connections only radio button it selected. So I try selecting the Remote radio button and Apply and Ok and then exit the Surface Area Configurator program and then come back in again and the Local Only is selected.

Is this normal behavior? Is Remote connections allowed or not? How verify?

Thanks.

hi,

do you mean you set the "Allow remote connections" setting and suddenly (the other day) it turned it OFF by magic? and since then (the other day) you are no longer able to enable "remote connections"?

please verify via the SQL Server Configuration Manager you do have a network protocol enabled, restart the SQL Server engine service and, via SAC check remote connections are enabled..

regards

|||

TCP/IP and Shared memory are enabled, and the engine and browser are running.

Remote connections where working, so yes the other day all stopped!

When I start up SAC the Local Only radio button is enabled. So I enabled remote and applied and ok'd.

Come back into SAC again and the Local Only radio button is enabled.

Is this proper behavior, meaning the program never saves the setting?

|||

hi,

Expressman wrote:

Is this proper behavior, meaning the program never saves the setting?

actually not.. did you try restarting the service?

regards

|||

Yes I restart the engine and browser!

I wonder if there could be a virus or hack out now doing it?!

When installing 2005 Express Edition does it associate the
ip address with the database even though ya used a name?

|||

I installed the MS SSEUtil program.

'sseutil - listsrv' command *without quotes' doesn't show any server running. lolol

Yet my program can access the database using the 'computername and instance name'.

Any ideas?

Could a system service not be running?

|||

hi,

Expressman wrote:

I installed the MS SSEUtil program.

'sseutil - listsrv' command *without quotes' doesn't show any server running. lolol

Yet my program can access the database using the 'computername and instance name'.

Any ideas?

Could a system service not be running?

you are probably using a "User Instance"... User Instances do not allow remote connections..

have a look at http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp for further info about this feature..

regards

|||

My new and my old applications used to work remotely without problems.
Both could connect using the server name or ip address.

Now neither one works now, meaning they can't connect.
Message is that the server doesn't exist.

I can only connect using the server name now, NOT the ip address.

I even tried connection with fire wall off. Buggers!

|||

Well I re-installed the database and all works. Thanks to all helping.

connection to SQL Server files (*.mdf) require SQL server express 2005 to function properl

I dont have the SQL EXPRESS installed instead I have SQL Standard Edition.

I have two SQL Server instances installed.

1- UserLT (this is sql 2000)
2- UserLT\SQL2005 (this is SQL 2005 named instance)

But when i try to add a database to my VS website project I get the following error:

Connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/?linkId=4925

I went in Tools>Opetions>DataBase tools>Data Connection>Sql Server Instance Name (blank for default)

and changed the "SQLEXPRESS" to "USERLT\SQL2005".

But I still get the same error message. Any ideas how i can resolve this issue?

Hello,

Attach the files to your SQL server instance using for example the SQL management Studio and change your connectionstring to connect into this database.

|||

Well the thing is that I dont have a database created yet. I am trying to create a new database. If i create a database in SQL 2005 then my connectionstring will point to the database on sql server. I need the database to reside in the VS project like a stand alone .mdf file so that I can deply the database with my project.

Does that make sense? Thanks for your help.

|||

Hi,

You may open your Machine.Config file (the file is in %SystemRoot%\Microsoft.NET\Framework\ver. number\CONFIG ). Try to find the ConnectionString node, modify the setting and make it look like

<add name="LocalSqlServer" connectionString="data source=UserLT\SQL2005;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient" />

Thanks.

Connection to SQL Server

I have installed MS SQL Server 2005 Express Edition with Advanced Services and MS SQL Server 2005 Express Edition Toolkit SP1. Everything istalled without any errors noted. When starting SQL Server Management Studio Express, accepting the server name MAYNARD-MAIN with authentication as windows authentication. I get the following message:

Cannot connect to MAYNARD-MAIN

Additional information:

An error has occurred while establishing a connection to the server. Wehn connecting to SQL Server 2005, this failure may be caused by the fact that under the default setting SQL Server does not allow remote connections.(provider:Shared Memory Provider, error:36 - The Shared Memory dll used to connect to SQL Server was not found)(Microsoft SQL Server, Error: 126)

I haven found any info on either of these error in the forum.

The Configuration Manager shows the following:

SQL Server FullTextSearch(SQLEXPRESS) - Running

SQL Server(SQLEXPRESS) - Running

SQL Server Reporting Services(SQLEXPRESS) - Running

SQL Server Browser - Running

Protocols for SQLEXPRESS

Shared Memory - Enabled

All others disabled

Client Protocols

Shared Memory - Order 1 - Enabled

TCP/IP - Order 2 - Enabled

Named Pipes - Order 3 - Enabled

VIA - Disabled.

What do I need to be trying to find to corect this.

Either connect to the default server instance..."SQLEXPRESS" or Make sure that the "MAYNARD_MAN" instance is running before trying to connect to it|||Well that was easy enough - I really feel dumb now. Add instance to machine name and it works a lot better. Sorry I took up your time being not to bright.

Connection Timeout

Hi, I have a client application that submits heavy processing query to an instance of Sql Server 2005 (Enteriprise Edition). After a few seconds the following exception is raised: "The time available has expired before the completion of the operation or the server is not responding". If I submit to the same application light processing queries the exception is not raised.
The client application is written in VB.net and uses ADO.net. (SqlConnection, SqlCommand,.. classes). The "Timeout connection" property is set to 1000.
Any suggestion?
Thank you.

Hi Ivan,

The ConnectionTimeout property of SqlConnection defines the time boundaries to open a physical connection to the SQL Server. In your case, the physical connection seems to be established within a reasonable frame. However, after the connection is up, the client and the server begin exchanging security information as part of the login process. This is related to a different "login timeout", which unfortunately you don't seem to be able to control from SqlClient.

What is happening on the server during the login process is related to the SOS scheduler operations - I won't go into deep detail, but in a nutshell all the tasks (including processing of login information) are queued. If the queue length is very long, the login information processing may be delayed beyond the login timeout and you will experience your symptoms above. There could also be other factors - the login processing makes calls to the security subsystem, if the entire SQL machine is under heavy stress, those may take longer time, too. You should approach this as a perf problem and use appropriate tools like perfmon, the SOS DMVs, etc.

HTH,
Jivko Dobrev - MSFT
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Connection Timeout is the timeout for connecting to SQL Server. What you need is COMMAND timeout. Set COMMAND timeout=0 for indefinite period.

Command timeout has to be set on the command object - because it is related to a particular SQL processing.

Connection String MSSQL2005

Dear all,
Do you people know how to connect MSSQL 2005 express edition with Vb6
ADODB? As I know MSSQL 2005 express connection string is specific the
database path. How do I write the connection string for ADODB?
Thanks in advance,
Goh
Hi Goh,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you would like to connect to SQL
Server 2005 Express via VB6. If I have misunderstood your concern, please
feel free to point it out.
We have a MSDN article that describes how to connect SQL Server 2005
Express from VB6.
Using SQL Express from Visual Basic 6
http://msdn.microsoft.com/vbrun/vbfu...ingsqlexpress/
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

Connection String MSSQL2005

Dear all,
Do you people know how to connect MSSQL 2005 express edition with Vb6
ADODB? As I know MSSQL 2005 express connection string is specific the
database path. How do I write the connection string for ADODB?
Thanks in advance,
GohHi Goh,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you would like to connect to SQL
Server 2005 Express via VB6. If I have misunderstood your concern, please
feel free to point it out.
We have a MSDN article that describes how to connect SQL Server 2005
Express from VB6.
Using SQL Express from Visual Basic 6
http://msdn.microsoft.com/vbrun/vbf...singsqlexpress/
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.

Connection string for VBEE to SQL 2005

I have SQL 2005 and I wanted to write a little program in Visual Basic 2005 Express Edition (VBEE) to carry out some processes. While away I built my user form, but when I got back I found that VBEE refuses to connect to SQL Server 2005 and is only configured to link to SQL Express.

The data source is set to .\SQLEXPRESS in the advanced properties of the Add Connection form in the Data Source Configuration Wizard and you can not change it.

I read in MSDN ID 329721 that you can create a data layer that will allow you to use the wizards, but that is as far as it went and is above my programming skills.

So my only options are use VB.Net 2003 Standard edition, use connected mode or give up and it was only supposed to be a quick fix. Had anyone else had this same issue and developed a work around?I have entered the following

Imports System.Data.SqlClient
Imports System.Data.OleDb
Public Class Form1
Public SQLPubsConnString As String = "Provider=SQLOLEDB;Data Source=TOTALLY-PBN-FS;Integrated Security=SSPI;Initial Catalog=Sword of Destiny Back End_Data.MDF"

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim cn As New OleDbConnection
cn.ConnectionString = SQLPubsConnString
cn.Open()

End Sub

and I get this error:

Request for the permission of type 'System.Data.OleDb.OleDbPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

I have no idea what this mean, I tried to connect to the help files and nothing, any clues would be appreciated|||Quick rant, why did Microsoft not include SQL 2005 within the Add Connection in VBEE, it is totally stupid?|||to connect to sql2005, you can use a connstr like this (assuming windows auth)

server=MYSERVER; database=MYDB; trusted_connection=yes;

many more examples here:
http://www.connectionstrings.com|||Many thanks, I tried it and it asks for a provider, I then enter one and it comes up with the same message. I had already located that excellent site and I have tried various permutations and no joy. I am using Windows Authorization by the way.

Sadly it looks like I will have to continue using my Access MDB front end that keeps getting ODBC timeouts which is not solvable.|||I worked out what it was while lying in bed, and sorted it this morning, it seems that as I had stored the project on a network drive it was tripping on security, as soon as I moved the project to My Documents the connection string worked, doh!!!|||you can store in your web.config



<add key="ConnectionString"
value="Server=(local);Database=yourDataBaseName;User ID=;Password=;Trusted_Connection=True"
/>

the keywords (local) works for localhost|||Thanks for your advice I will remember that as I will be setting up something for the Web, in the end I did this:

Public WithEvents cnn As New SqlConnection
Public SQLPubsConnString As String = "data source=TOTALLY-PBM-FS;Initial Catalog=Sword of Destiny Back End;Integrated Sec

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim SQLGetControlFormData As String
Dim SQLcommand As New SqlCommand

SQLGetControlFormData = "Select ID, [Character Name], Month, Year From dbo.[Control Form]"

cnn.ConnectionString = SQLPubsConnString
cnn.Open()

SQLcommand.Connection = cnn
SQLcommand.CommandText = SQLGetControlFormData

Dim DRControlForm As SqlDataReader = SQLcommand.ExecuteReader

Do While DRControlForm.Read()
Debug.WriteLine(DRControlForm.Item("ID"))
combobox6.
Loop

DRControlForm.Close()
SQLcommand.Dispose()

I can see the data in the immediate window, so its there, my next challenge is to work out how to get the data into the Form. And to do something like this which I Was doing in Access:

' GetUnitIDSQL = "SELECT [Unit Details].ID, [Unit Details].[Unit Name], [Unit Details].[Unit Type], [Unit Details].[Paid By], [Unit Details].Country, " & _
' "[Unit Details].[Province based], [Unit Details].[Training Level], [Unit Details].[Location], [Unit Details].[Wages PM] " & _
' "FROM [Unit Details] " & _
' "WHERE ((([Unit Details].[ID])=" & UNitID & ") AND (([Unit Details].[Unit Type])=" & "'" & UnitType & "'" & ") " & _
' "AND (([Unit Details].[Paid By])=" & CharID & ") AND (([Unit Details].Country)=" & "'" & Country & "'" & ") AND (([Unit Details].[Province based])=" & "'" & Province & "'" & "));"

' qdf2 = db.CreateQueryDef("Hewitt5734", GetUnitIDSQL)
' rs2 = db.OpenRecordset("Hewitt5734", Type:=dbOpenSnapshot)

' With rs2
' CountB = .RecordCount
' If CountB = 1 Then

' UnitName = .Fields("Unit Name")
' WagesPM = .Fields("Wages PM")
' StartSector = .Fields("Location")

' End If

' End With

' 'db.OpenRecordset("Hewitt5734").Close

' db.QueryDefs.Delete("Hewitt5734")

I do not intend to change any data I bring into the form, I want to use an Update SQL Query at the end to add new records in another table and update certain related records in another Table. As I can't use disconnected mode with this which is with the Wizards working of course then I have to use connected mode.

Connection String for SQL 2005 Express

Hi,
My C# app uses SQL Server 2005 Express edition.
I store my connection string in a config file.
My application will run on numerous machines and therefore the machine name
will be different each time. What I would like is a generic connection strin
g
so that I don't have to change it each time I install my app on a different
machine.
I therefore want to avoid specifing the machine name in the connection
string as shown below :-
"Data Source=MachineName;Initial Catalog=pubs;Integrated Security=SSPI;"
Is there any way to make this connection string generic so that it can stay
the same between different machines?
Thanks
MaccaIf you run your application on the same machine as the database, . (period)
works as a server name. So if your install SQL Express with the default
instance name, the server name is .\SQLEXPRESS
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Macca" <Macca@.discussions.microsoft.com> wrote in message
news:B0A6D9FF-6715-4BBD-83BB-0C8B1F9A7098@.microsoft.com...
> Hi,
> My C# app uses SQL Server 2005 Express edition.
> I store my connection string in a config file.
> My application will run on numerous machines and therefore the machine
> name
> will be different each time. What I would like is a generic connection
> string
> so that I don't have to change it each time I install my app on a
> different
> machine.
> I therefore want to avoid specifing the machine name in the connection
> string as shown below :-
> "Data Source=MachineName;Initial Catalog=pubs;Integrated Security=SSPI;"
> Is there any way to make this connection string generic so that it can
> stay
> the same between different machines?
> Thanks
> Macca

connection problem...

I have installed SQLEVAL and the service pach 3 on
Windows XP Home edition... now i can't use telnet/ftp
connection because my port23 is closed and i can't
uninstall SQL because there isn't an uninstallation file.
I don't know what i have to do.
thanks to much.
lmcHi
I have never used the EVAL edition, but...
I am not sure why you think that SQLServer will be using port 23?
You may want to check out the server network utitily in the SQL Server
program group.
If there is no add/remove program in control panel, have you check the
installation log to see that it worked? You may find a remove option in the
original setup program?
John
"lmc" <lmc76@.libero.it> wrote in message
news:006e01c3cc97$b1630350$a101280a@.phx.gbl...

quote:

---

> I have installed SQLEVAL and the service pach 3 on
> Windows XP Home edition... now i can't use telnet/ftp
> connection because my port23 is closed and i can't
> uninstall SQL because there isn't an uninstallation file.
> I don't know what i have to do.
> thanks to much.
> lmc

---