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,
> >> >
> >>
>

Connects but network error, Im behind Wingate

Hello.

I'm trying to connect to SQL Server using Enterprise manager. I'm behind a Wingate proxy.

I've configured an alias using TCP/IP, pointing to the (local network) IP of the Wingate box.

On the Wingate box I've set a TCP Mapping service on port 1433, pointing to the IP of the remote SQL Server on port 1433 too.

The error message is:
General network error. Changed language settings to us-english. ConnectionRead(Error SIO_KEEPALIVE_VALS())..

I assume at least *something* is right, as if I change the password to a bogus one I get "Login failed" instead of this network error.

Hope someone can point me in the right direction. Thanks,
- ManuelYou probably need to enable UDP port 1434 as well. See MSDN (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_1zuc.asp) for a more complete explaination.

-PatP|||Hello.

Just added UDP mapping on 1434. Same error.

Read the MSDN article but couldn't figure what else to try. Just in case I didn't make myself clear, I'm trying to connect to a server outside my local network (as opposed to enabling a server on my network to be seen on the internet).

How can I debug this forward? What else can I do?

Thanks again,
- Manuel|||Check the Wingate log, and look to see what traffic is blocked from the workstation headed toward the server's IP address. It should be on port 1433 unless you are using a named instance of SQL Server, but look for anything, just in case.

Triple check to be sure that your Client Network Settings (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_client_7v03.asp) and the server's Server Network Settings (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_2epl.asp) are compatible, especially if they are using a Proxy (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_1y5u.asp).

-PatP|||As referred by Pat ensure both client & server's netlibs are similar, by chance are you running on cluster?

Try to use Named-pipes instead of Tcp/IP.

Information about Orphaned sessions (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_rptconsetup_5gmr.asp) from this mSDN link.

HTH

Connectivity Issues - Bizzare

I am trying to connect to a default instance of SQL Server 2000 Enterprise on
a remote network server using ADO.NET objects through ASP.NET Web Application.
The SQL SERVER is on a Windows XP machine (no firewall enabled) with TCP/IP
and Named Pipes enabled
For the test purposes, I created a new Web Form, created a new SqlConnection
in the Server Explorer to the remote database. I test the connection is VS
IDE and everything is fine. I create a SqlDataAdapter on the web form,
generate a dataset, test the dataset and the results are valid. I bind the
SqlDataAdapter to a datagrid and run the webform. I now get the following
error.
System.Data.SqlClient.SqlException: SQL Server does not exist or access
denied.
at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean&
isInTransaction)
at
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString options, Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
at DBConnTest.WebForm1.Page_Load(Object sender, EventArgs e) in
c:\inetpub\wwwroot\dbconntest\webform1.aspx.cs:lin e 39
Hmph! I take the same connection string from the web app, create a win app.
Place a datagrid on the form, do the binding and load the app. Hey Presto! it
works.
I used TCPView (systeminternals.com) and I can see aspnet_wp trying to
create a connection, but its at though SQL Server is rejecting the
connection, although I see no failures in SQL Server.
Any thoughts would be much appreciated.
Andy
Sounds like firewall to me.
As a quick test to see if firewall is blocking port, try this from command
prompt on client machine ->
telnet mysqlmachine 1433
If you can't telnet to 1433, then you have firewall issue.
Matt Neerincx [MSFT]
This posting is provided "AS IS", with no warranties, and confers no rights.
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.
"Andy Furnival" <AndyFurnival@.discussions.microsoft.com> wrote in message
news:40AC00C0-0402-452B-AAC8-F25D97E94ACD@.microsoft.com...
>I am trying to connect to a default instance of SQL Server 2000 Enterprise
>on
> a remote network server using ADO.NET objects through ASP.NET Web
> Application.
> The SQL SERVER is on a Windows XP machine (no firewall enabled) with
> TCP/IP
> and Named Pipes enabled
> For the test purposes, I created a new Web Form, created a new
> SqlConnection
> in the Server Explorer to the remote database. I test the connection is VS
> IDE and everything is fine. I create a SqlDataAdapter on the web form,
> generate a dataset, test the dataset and the results are valid. I bind the
> SqlDataAdapter to a datagrid and run the webform. I now get the following
> error.
> System.Data.SqlClient.SqlException: SQL Server does not exist or access
> denied.
> at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean&
> isInTransaction)
> at
> System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString
> options, Boolean& isInTransaction)
> at System.Data.SqlClient.SqlConnection.Open()
> at DBConnTest.WebForm1.Page_Load(Object sender, EventArgs e) in
> c:\inetpub\wwwroot\dbconntest\webform1.aspx.cs:lin e 39
> Hmph! I take the same connection string from the web app, create a win
> app.
> Place a datagrid on the form, do the binding and load the app. Hey Presto!
> it
> works.
> I used TCPView (systeminternals.com) and I can see aspnet_wp trying to
> create a connection, but its at though SQL Server is rejecting the
> connection, although I see no failures in SQL Server.
> Any thoughts would be much appreciated.
> Andy

Connectivity Issues - Bizzare

I am trying to connect to a default instance of SQL Server 2000 Enterprise o
n
a remote network server using ADO.NET objects through ASP.NET Web Applicatio
n.
The SQL SERVER is on a Windows XP machine (no firewall enabled) with TCP/IP
and Named Pipes enabled
For the test purposes, I created a new Web Form, created a new SqlConnection
in the Server Explorer to the remote database. I test the connection is VS
IDE and everything is fine. I create a SqlDataAdapter on the web form,
generate a dataset, test the dataset and the results are valid. I bind the
SqlDataAdapter to a datagrid and run the webform. I now get the following
error.
System.Data.SqlClient.SqlException: SQL Server does not exist or access
denied.
at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean&
isInTransaction)
at
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnec
tionString options, Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
at DBConnTest.WebForm1.Page_Load(Object sender, EventArgs e) in
c:\inetpub\wwwroot\dbconntest\webform1.aspx.cs:line 39
Hmph! I take the same connection string from the web app, create a win app.
Place a datagrid on the form, do the binding and load the app. Hey Presto! i
t
works.
I used TCPView (systeminternals.com) and I can see aspnet_wp trying to
create a connection, but its at though SQL Server is rejecting the
connection, although I see no failures in SQL Server.
Any thoughts would be much appreciated.
AndySounds like firewall to me.
As a quick test to see if firewall is blocking port, try this from command
prompt on client machine ->
telnet mysqlmachine 1433
If you can't telnet to 1433, then you have firewall issue.
Matt Neerincx [MSFT]
This posting is provided "AS IS", with no warranties, and confers no rights.
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.
"Andy Furnival" <AndyFurnival@.discussions.microsoft.com> wrote in message
news:40AC00C0-0402-452B-AAC8-F25D97E94ACD@.microsoft.com...
>I am trying to connect to a default instance of SQL Server 2000 Enterprise
>on
> a remote network server using ADO.NET objects through ASP.NET Web
> Application.
> The SQL SERVER is on a Windows XP machine (no firewall enabled) with
> TCP/IP
> and Named Pipes enabled
> For the test purposes, I created a new Web Form, created a new
> SqlConnection
> in the Server Explorer to the remote database. I test the connection is VS
> IDE and everything is fine. I create a SqlDataAdapter on the web form,
> generate a dataset, test the dataset and the results are valid. I bind the
> SqlDataAdapter to a datagrid and run the webform. I now get the following
> error.
> System.Data.SqlClient.SqlException: SQL Server does not exist or access
> denied.
> at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean&
> isInTransaction)
> at
> System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConn
ectionString
> options, Boolean& isInTransaction)
> at System.Data.SqlClient.SqlConnection.Open()
> at DBConnTest.WebForm1.Page_Load(Object sender, EventArgs e) in
> c:\inetpub\wwwroot\dbconntest\webform1.aspx.cs:line 39
> Hmph! I take the same connection string from the web app, create a win
> app.
> Place a datagrid on the form, do the binding and load the app. Hey Presto!
> it
> works.
> I used TCPView (systeminternals.com) and I can see aspnet_wp trying to
> create a connection, but its at though SQL Server is rejecting the
> connection, although I see no failures in SQL Server.
> Any thoughts would be much appreciated.
> Andy

connectivity error while registering a new group

While registering sqlserver group I am getting the following
error message
"You must upgrade your SQL Enterprise Manager and SQL DMO (SQL-OLE) to SQL server (SQL DMO) to connect to server."
Can any one please guide me how to overcome this proble.
thanx regardsLook at Knowledge Base Article:

HOW TO: Administer Different Versions of SQL Server by Using SQL Server Enterprise Manager (http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q225/5/45.asp&NoWebContent=1)sqlsql

Connectiong to SQL Server 2000 over VPN

Hi, hoping someone can help me out here. I am opening enterprise manager and trying to register a new server for which I have permissions. When I use windows authentication I get "Login Failed for user "(null)" and when I use SQL Server Authentication I get "Login failed for user "sa".

I am VPN'd in to the companies network. I am not on their domain, I am on a domain at my current location. I think the problem is that I am not logged on to their domain therefore it can't see me as the user I am on that domain. Is there any way to trick this, or simply to get it to work?

Thanks in advance.Can you reach the server on the VPN (ping it) ?
if not, you need to reconfigurate your network settings(IP of the switch connectiong to the VPN)
if you can ping it, you should have no problem using SQL server Authentication (unless firewall filter the SQL Server port)

Originally posted by kevin86
Hi, hoping someone can help me out here. I am opening enterprise manager and trying to register a new server for which I have permissions. When I use windows authentication I get "Login Failed for user "(null)" and when I use SQL Server Authentication I get "Login failed for user "sa".

I am VPN'd in to the companies network. I am not on their domain, I am on a domain at my current location. I think the problem is that I am not logged on to their domain therefore it can't see me as the user I am on that domain. Is there any way to trick this, or simply to get it to work?

Thanks in advance.|||I can ping the server. I can also access shared folders on this server. When I use SQL Authentication I have tried using SA, our Admin account, and an account set up for me and they all say login failed for user.

How could I check to see if the firewall is blocking it? I don't think this is the problem but I guess it could be?|||I think you have to ask to the system admin for the firewall.

Do you asked someone on the domain (not using the VPN) to try login SQL server with the same users you tried ?

Originally posted by kevin86
I can ping the server. I can also access shared folders on this server. When I use SQL Authentication I have tried using SA, our Admin account, and an account set up for me and they all say login failed for user.

How could I check to see if the firewall is blocking it? I don't think this is the problem but I guess it could be?|||Someone on the domain was able to log in using the id's I tried.

I just spoke to our network admin and these ports are not blocked. Any other suggestions?|||Originally posted by kevin86
Someone on the domain was able to log in using the id's I tried.

I just spoke to our network admin and these ports are not blocked. Any other suggestions?

You cannot register as windows nt user (trusted) cos you might not be added to that server as a user, and as you are able to ping the server , you are suppose to register the server using sql login, the only reason i would say you are not able to register is the sa password is wrong, try overwriting the password froom any of the machines where its already connected and then register it ...you should be able to connect ...

Connectiong to MSDE 2000

I installed MSDE 2000 on my machine running XP home
edition.
I can connect with all client utilities, include, query
analiser, enterprise manager, odbc, etc if i use the
builtin/administrator id, but i cant connect in the SQL
MODE.
If i set up an odbc connection for test, i get the
following error
Attempting connection
[Microsoft][ODBC SQL Server Driver][SQL Server]Login
failed for user 'sa'. Reason: Not associated with a
trusted SQL Server connection.
The ODBC error returns a state 28000 error, with is an
authenticaton error, please how can i correct thisMSDE is installed by default with Windows authentication, not with mixed
authentication, so you can't login with a SQL login, like 'sa'. You can
change this from Enterprise Manager by rightclicking the server, choosing
properties, and change the Authentication on the Security tab. You ahve to
restart SQL Server for the setting to take effect.
Jacco Schalkwijk
SQL Server MVP
"Lanre" <larry548997@.yahoo.com_anonymous> wrote in message
news:1b8701c3fc16$8a0ec650$a401280a@.phx.gbl...
> I installed MSDE 2000 on my machine running XP home
> edition.
> I can connect with all client utilities, include, query
> analiser, enterprise manager, odbc, etc if i use the
> builtin/administrator id, but i cant connect in the SQL
> MODE.
> If i set up an odbc connection for test, i get the
> following error
> Attempting connection
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login
> failed for user 'sa'. Reason: Not associated with a
> trusted SQL Server connection.
> The ODBC error returns a state 28000 error, with is an
> authenticaton error, please how can i correct this|||If you don't have Enterprise Manager, you can change the setting with the
steps from this article:
285097 INF: How to Change the Default Login Authentication Mode to SQL While
http://support.microsoft.com/?id=285097
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Connection still apperas in SQLServer Entreprise Manager over Locks / process ID

Hello,
i have a doubt here, after a close the connection, i still can see the last stored procedure active in the LOCKS/PROCESSID in enterprise manager of SQL SERVER.
I think i'm closing the connection well

Try

IfMe.ID > 0Then

Dim strSqlAsString = "SP_CHANGECLASSCONTENTS"

Dim sqlcommandAsNew SqlCommand(strSql,New SqlConnection(ConnStr))

sqlcommand.CommandType = CommandType.StoredProcedure

sqlcommand.Parameters.Add("@.PerformActivation", SqlDbType.Bit).Value = 0

sqlcommand.Parameters.Add("@.PerformInactivation", SqlDbType.Bit).Value = 0

sqlcommand.Parameters.Add("@.PerformDelete", SqlDbType.Bit).Value = 1

sqlcommand.Parameters.Add("@.PerformUndelete", SqlDbType.Bit).Value = 0

sqlcommand.Parameters.Add("@.PermanentDelete", SqlDbType.Bit).Value = CBit(PermanentDelete)

sqlcommand.Parameters.Add("@.Class_ID", SqlDbType.Int).Value = _id

sqlcommand.Connection.Open()

sqlcommand.ExecuteNonQuery()

sqlcommand.Connection.Close()

Else

Err.Raise(10205, "CLASS", "CLASS ID is empty")

EndIf

Catch exAs Exception

_err = ex.Message

Return Err.Number

EndTry

Hi,

.NET Framework SQl data provider utilizes database connection pooling (there's one pool per unique connection string). When you close a SqlConnection, it is returned to this pool (there are min amount of connections in the pool ) and the hard connection to the db is not necessarily closed (connection ).
E.g this way usage of connections is kept efficient and opening & closing of "real connections" is kept minimum.
Here's more details
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconconnectionpoolingforsqlservernetdataprovider.asp

|||ok tks,
but what if i use many procedures like this one several times, and each one creates it's own connection. Even if i close the connection well it still appears several processes concerning this procedures in SQLSERVER. does this degrades the performance ?
tks|||

Hi,
see the previous link for exact details.
Anyways, it happens within the limits of the connection pool. If there are free connections in the pool, they are utilized to fullfill those which you instantiate and run e.g even if you instantiate new connections in code, the pool might be able to deal with them without increasing its size (the actual pooled connections are of type SqlInternalConnection not those which SqlConnection objects which you instantiate).
If the pool cannot deal with new connection requests, it starts creating new ones (within the max limit of the pool). If max limit is reached then new connection requests are queued. Note also that after a burst usage of connections, they are also dropped from the pool to the mimum limit when lifetime has expired or connectiion is severed.

E.g the pools are there to keep connection count in control in situation like these.

Connection Prodlem-with instance node

Hi
I have an active/passive sql server 2000 cluster. Most of the time I remote-login into the server and use the enterprise manager to work. But now when I click on either of the node I get the following error:
Encryption not supported on SQL Server ConnectionOpen (PreLoginHandshake())
But I'm able to connect to the server from my desktop.
Any help in this regard?
Thanks,
This means that the "Enable Protocol Encryption" option was set on the
machine you're using as a client.
Use the SQL Client Network Utility to uncheck this.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||Hi Kevin
Thank you so much it worked.
Razi
"Kevin McDonnell [MSFT]" wrote:

> This means that the "Enable Protocol Encryption" option was set on the
> machine you're using as a client.
> Use the SQL Client Network Utility to uncheck this.
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>
|||You're welcome!
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Connection Prodlem-with instance node

Hi
I have an active/passive sql server 2000 cluster. Most of the time I remote-
login into the server and use the enterprise manager to work. But now when I
click on either of the node I get the following error:
Encryption not supported on SQL Server ConnectionOpen (PreLoginHandshake())
But I'm able to connect to the server from my desktop.
Any help in this regard?
Thanks,This means that the "Enable Protocol Encryption" option was set on the
machine you're using as a client.
Use the SQL Client Network Utility to uncheck this.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Hi Kevin
Thank you so much it worked.
Razi
"Kevin McDonnell [MSFT]" wrote:

> This means that the "Enable Protocol Encryption" option was set on the
> machine you're using as a client.
> Use the SQL Client Network Utility to uncheck this.
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>|||You're welcome!
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Connection problems

I just installed 2005 and have an instance of Enterprise on my local machine. My SSAS service appears to be working properly in Services. However, whenever I try to deploy a cube (simple one from tutorial) or try to connect from Management Console, I get rejected. The error message is:

No connection could be made because the target machine actively refused it (System).

I've tried about everything I can think of and can't get past this. Any guidance would be greatly appreciated.

If you have a named instance installed (you can tell by looking at the service name "SQL Server Analysis Services (INSTANCE_NAME)"), then you need to set the Target Server project property (right click on the Analysis Services project in VS, use Properties, go to Deployment tab and set Server to "localhost\INSTANCE_NAME").

If you are disconnected from the network, try using 127.0.0.1 instead of machine name.

Adrian Dumitrascu

|||I'm dealing with the same problem. But as I can se I don't have an instance of Analysis Service running. I have just an instance of Database Engine (my_host_name\SQLExpress). How can I create an instance of Analysis Services? Please!!!|||

If you don't have the "SQL Server Analysis Services" service at all (default instance or named instance), you'll need to re-run Setup to install it.

Adrian Dumitrascu