enumerating sql servers in sql server 2005

Is there anyway new in SQL Server 2005 to enumerate all the servers on the
network without sqldmo? I'm working in .NET and want to get the list, im
doing it now in sqldmo and it works fine, but would like to do it with
managed code instead of using a com object...smo. It is the new dmo. :-)
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
***************************
Think Outside the Box!
***************************
"Brian Henry" wrote:

> Is there anyway new in SQL Server 2005 to enumerate all the servers on the
> network without sqldmo? I'm working in .NET and want to get the list, im
> doing it now in sqldmo and it works fine, but would like to do it with
> managed code instead of using a com object...
>
>|||Or use new ado.net class SqlDataSourceEnumerator, for example:
foreach (DataRow row in
SqlDataSourceEnumerator.Instance.GetDataSources().Rows)
{
Console.WriteLine(row["ServerName"].ToString());
}
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
"Brian Henry" <nospam@.nospam.com> wrote in message
news:%23ttiTlzBGHA.3840@.TK2MSFTNGP15.phx.gbl...
> Is there anyway new in SQL Server 2005 to enumerate all the servers on the
> network without sqldmo? I'm working in .NET and want to get the list, im
> doing it now in sqldmo and it works fine, but would like to do it with
> managed code instead of using a com object...
>|||thanks a lot!
"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:%23DEvJk0BGHA.2840@.TK2MSFTNGP12.phx.gbl...
> Or use new ado.net class SqlDataSourceEnumerator, for example:
> foreach (DataRow row in
> SqlDataSourceEnumerator.Instance.GetDataSources().Rows)
> {
> Console.WriteLine(row["ServerName"].ToString());
> }
>
> --
> Miha Markic [MVP C#]
> RightHand .NET consulting & development www.rthand.com
> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
> "Brian Henry" <nospam@.nospam.com> wrote in message
> news:%23ttiTlzBGHA.3840@.TK2MSFTNGP15.phx.gbl...
>|||do you happen to know a way to list all the databases on a selected server
also with out having to log into it? SQLDMO let you do this before
"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:%23DEvJk0BGHA.2840@.TK2MSFTNGP12.phx.gbl...
> Or use new ado.net class SqlDataSourceEnumerator, for example:
> foreach (DataRow row in
> SqlDataSourceEnumerator.Instance.GetDataSources().Rows)
> {
> Console.WriteLine(row["ServerName"].ToString());
> }
>
> --
> Miha Markic [MVP C#]
> RightHand .NET consulting & development www.rthand.com
> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
> "Brian Henry" <nospam@.nospam.com> wrote in message
> news:%23ttiTlzBGHA.3840@.TK2MSFTNGP15.phx.gbl...
>|||whoops i made a mistake i didnt mean not logging in... in SQLDMO i'd do this
Dim oSQLServer As New SQLDMO.SQLServer
oSQLServer.LoginSecure = True
oSQLServer.Connect(s_Server)
Me.cboDatabaseList.Items.Clear()
For Each db As SQLDMO.Database In oSQLServer.Databases
If Not db.SystemObject Then
Dim dbName As String = db.name
Me.cboDatabaseList.Items.Add(dbName)
End If
End If
End If
End If
Next
how would you do that now without sqldmo?|||Here is how - http://blogs.msdn.com/sushilc/archi.../14/242395.aspx
- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.m...5/13/63199.aspx
________________________________________
__________________
"Brian Henry" <nospam@.nospam.com> wrote in message
news:%23ttiTlzBGHA.3840@.TK2MSFTNGP15.phx.gbl...
> Is there anyway new in SQL Server 2005 to enumerate all the servers on the
> network without sqldmo? I'm working in .NET and want to get the list, im
> doing it now in sqldmo and it works fine, but would like to do it with
> managed code instead of using a com object...
>

Enumerate SQL servers?

I'm working on an Access app that will have a SQL 2K backend. My setup will
install MSDE, and I will set the sa password, etc. which I don't want the
end user's to know. My problem is in Relinking the ODBC tables once it is
installed in the field. The one item I won't know is the name of the server
MSDE is installed on. I want to prompt the user to pick the server from a
list, much like you do when creating a DSN through the ODBC Administrator. I
can't use the ODBC Administrator to create a DSN because if the user doesn't
enter the sa password, it fails; also, I want to use DSN-less connections.
But I can't seem to find an API call to enumerate the SQL servers available
on the network. Does anyone know of an API to call? Alternatively, some code
to enumerate SQL servers running on the LAN? TIA!Can also look at :
http://www.extremeexperts.com/sql/f...istServers.aspx
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
"Ron Hinds" <__NoSpam@.__NoSpamramac.com> wrote in message
news:%23rKHj4H3DHA.1392@.TK2MSFTNGP11.phx.gbl...

quote:

---

> I'm working on an Access app that will have a SQL 2K backend. My setup

---

will

quote:

---

> install MSDE, and I will set the sa password, etc. which I don't want the
> end user's to know. My problem is in Relinking the ODBC tables once it is
> installed in the field. The one item I won't know is the name of the

---

server

quote:

---

> MSDE is installed on. I want to prompt the user to pick the server from a
> list, much like you do when creating a DSN through the ODBC Administrator.

---

I

quote:

---

> can't use the ODBC Administrator to create a DSN because if the user

---

doesn't

quote:

---

> enter the sa password, it fails; also, I want to use DSN-less connections.
> But I can't seem to find an API call to enumerate the SQL servers

---

available

quote:

---

> on the network. Does anyone know of an API to call? Alternatively, some

---

code

quote:

---

> to enumerate SQL servers running on the LAN? TIA!
>

---

|||Hi Vinodk,
I can list SQL server instances on my personal computer fairly easily using
SQLBrowseConnect and associated methods but I have trouble trying to
enumerate all SQL servers on the network if I am not connected to a browser
service. Obviously, I don't expect to get a list of servers if I am not
connected but I can't seem to get a *faster* way to check if I am connected
to the browser service.
I use something like the folowing to see if any master browsers are
available in hopes for speed bit it is very slow. If the status return
ERROR_NO_BROWSER_SERVERS_FOUND, I don't want to go further.
nStatus = NetServerEnum(NULL,
(DWORD)100,
(LPBYTE *) &pBufServerBrowser,
dwPrefMaxLen,
&dwEntriesRead,
&dwTotalEntries,
SV_TYPE_DOMAIN_MASTER |
SV_TYPE_POTENTIAL_BROWSER |
SV_TYPE_BACKUP_BROWSER |
SV_TYPE_MASTER_BROWSER,
NULL,
&dwResumeHandle);
Any thoughts on this'
Thanks in advance for any help...
Regards,
Chris H
"Vinodk" <vinodk_sct@.NO_SPAM_hotmail.com> wrote in message
news:eXEf9iL3DHA.2296@.TK2MSFTNGP11.phx.gbl...
> Can also look at :
> http://www.extremeexperts.com/sql/f...istServers.aspx
> --
> HTH,
> Vinod Kumar
> MCSE, DBA, MCAD, MCSD
> http://www.extremeexperts.com
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp
>
> "Ron Hinds" <__NoSpam@.__NoSpamramac.com> wrote in message
> news:%23rKHj4H3DHA.1392@.TK2MSFTNGP11.phx.gbl...
> will
the
is
> server
a
Administrator.
> I
> doesn't
connections.
> available
> code
>

Enumerate SQL server list?

Anyone know how to enumerate the SQL Servers on a network using .Net? I can
do this with VB6, but howso in .Net?
Hi Earl,
One way would be:
Q287737
http://support.microsoft.com/default...EN-US;Q287737&
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com
"Earl comcast net>" <brikshoe<at.> wrote in message
news:%23YXdcy5FEHA.2208@.TK2MSFTNGP09.phx.gbl...
> Anyone know how to enumerate the SQL Servers on a network using .Net? I
can
> do this with VB6, but howso in .Net?
>
|||I haven't seen how to do it using the .Net Framework, but if the method you use for VB6 provides a COM object interface, you can include a reference to the library in your project. .Net will create the classes required for the mashalling between the manag
ed and unmanaged code.
|||Earl,
This is worth looking at to give you some ideas. It's not .net though.
http://sqldev.net/misc/ListSQLSvr.htm
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
|||Hi Mika,
This is essentially the same thing I'm doing now in VB6, but I was looking
to see if there was another way to not use a COM reference in order to do
this with .Net. Maybe this is the wrong way of looking at this -- what am I
giving up using COM here? Incidentally, I've been on that RightHand site in
the past, good stuff you folks are building over there.
"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:OyYPu47FEHA.3188@.TK2MSFTNGP10.phx.gbl...
> Hi Earl,
> One way would be:
> Q287737
> http://support.microsoft.com/default...EN-US;Q287737&
> --
> Miha Markic [MVP C#] - RightHand .NET consulting & software development
> miha at rthand com
> www.rthand.com
> "Earl comcast net>" <brikshoe<at.> wrote in message
> news:%23YXdcy5FEHA.2208@.TK2MSFTNGP09.phx.gbl...
> can
>
|||Miha,
Using this VB6 method, I get an invalid cast exception when I try to create
an object for the namelist (Dim oNames As SQLDMO.NameList). Even with a
Try-Catch, I still get the exception: "Query Interface for interface
SQLDMO.Namelist failed." Is this a COM wrapper issue?
"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:OyYPu47FEHA.3188@.TK2MSFTNGP10.phx.gbl...
> Hi Earl,
> One way would be:
> Q287737
> http://support.microsoft.com/default...EN-US;Q287737&
> --
> Miha Markic [MVP C#] - RightHand .NET consulting & software development
> miha at rthand com
> www.rthand.com
> "Earl comcast net>" <brikshoe<at.> wrote in message
> news:%23YXdcy5FEHA.2208@.TK2MSFTNGP09.phx.gbl...
> can
>
|||Hehe, thanks Mark... I've read this and every article I could find on the
web about this topic and they all pertain to VB6. Gets me close though.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:814797B0-7FBF-4D8A-8ABA-0CB3B8EBCE08@.microsoft.com...
> Earl,
> This is worth looking at to give you some ideas. It's not .net though.
> http://sqldev.net/misc/ListSQLSvr.htm
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
|||Thanks Al, the problem I'm having is that apparently one of the classes is
not being created because I get an error trying to assign the list object to
the name object.
Dim oSQLNames As SQLDMO.NameList
Dim oSQLApp As SQLDMO.Application
oSQLApp = New SQLDMO.Application
'getting invalid cast error on this assignment
oSQLNames = oSQLApp.ListAvailableSQLServers
"Al" <al_davie@.hotmail.com> wrote in message
news:A7B8DA42-0D39-4529-B2AE-9C8DAED59F1B@.microsoft.com...
> I haven't seen how to do it using the .Net Framework, but if the method
you use for VB6 provides a COM object interface, you can include a reference
to the library in your project. .Net will create the classes required for
the mashalling between the managed and unmanaged code.
|||Hi,
I've just tried your code fragment, and I don't get a problem.
Are you getting the problem in the debugger or deployed ?
Here are the facts for my set-up :-
VS 2003 / Framework 1.1
SQL Server 2000 SP3 (not Sp3a)
Windows 2000Pro SP4
Running via debugger, so not deployed.
Visual Basic Windows application
Option Explicit ON
Option Strict OFF
Option Compare Binary
The Imports and References are all the defaults for a Windows Application, excepted added the SQLDMO Object lib version 8.0
Let me know how you get on
|||If you're getting stuck, send me the source.
Email my Hotmail account, i'll send you my main email address.

Enumerate SQL server list?

Anyone know how to enumerate the SQL Servers on a network using .Net? I can
do this with VB6, but howso in .Net?Hi Earl,
One way would be:
Q287737
http://support.microsoft.com/defaul...;EN-US;Q287737&
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com
"Earl comcast net>" <brikshoe<at.> wrote in message
news:%23YXdcy5FEHA.2208@.TK2MSFTNGP09.phx.gbl...
> Anyone know how to enumerate the SQL Servers on a network using .Net? I
can
> do this with VB6, but howso in .Net?
>|||I haven't seen how to do it using the .Net Framework, but if the method you
use for VB6 provides a COM object interface, you can include a reference to
the library in your project. .Net will create the classes required for the m
ashalling between the manag
ed and unmanaged code.|||Earl,
This is worth looking at to give you some ideas. It's not .net though.
http://sqldev.net/misc/ListSQLSvr.htm
Mark Allison, SQL Server MVP
http://www.markallison.co.uk|||Hi Mika,
This is essentially the same thing I'm doing now in VB6, but I was looking
to see if there was another way to not use a COM reference in order to do
this with .Net. Maybe this is the wrong way of looking at this -- what am I
giving up using COM here? Incidentally, I've been on that RightHand site in
the past, good stuff you folks are building over there.
"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:OyYPu47FEHA.3188@.TK2MSFTNGP10.phx.gbl...
> Hi Earl,
> One way would be:
> Q287737
> http://support.microsoft.com/defaul...;EN-US;Q287737&
> --
> Miha Markic [MVP C#] - RightHand .NET consulting & software developmen
t
> miha at rthand com
> www.rthand.com
> "Earl comcast net>" <brikshoe<at.> wrote in message
> news:%23YXdcy5FEHA.2208@.TK2MSFTNGP09.phx.gbl...
> can
>|||Miha,
Using this VB6 method, I get an invalid cast exception when I try to create
an object for the namelist (Dim oNames As SQLDMO.NameList). Even with a
Try-Catch, I still get the exception: "Query Interface for interface
SQLDMO.Namelist failed." Is this a COM wrapper issue?
"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:OyYPu47FEHA.3188@.TK2MSFTNGP10.phx.gbl...
> Hi Earl,
> One way would be:
> Q287737
> http://support.microsoft.com/defaul...;EN-US;Q287737&
> --
> Miha Markic [MVP C#] - RightHand .NET consulting & software developmen
t
> miha at rthand com
> www.rthand.com
> "Earl comcast net>" <brikshoe<at.> wrote in message
> news:%23YXdcy5FEHA.2208@.TK2MSFTNGP09.phx.gbl...
> can
>|||Hehe, thanks Mark... I've read this and every article I could find on the
web about this topic and they all pertain to VB6. Gets me close though.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:814797B0-7FBF-4D8A-8ABA-0CB3B8EBCE08@.microsoft.com...
> Earl,
> This is worth looking at to give you some ideas. It's not .net though.
> http://sqldev.net/misc/ListSQLSvr.htm
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk|||Thanks Al, the problem I'm having is that apparently one of the classes is
not being created because I get an error trying to assign the list object to
the name object.
Dim oSQLNames As SQLDMO.NameList
Dim oSQLApp As SQLDMO.Application
oSQLApp = New SQLDMO.Application
'getting invalid cast error on this assignment
oSQLNames = oSQLApp.ListAvailableSQLServers
"Al" <al_davie@.hotmail.com> wrote in message
news:A7B8DA42-0D39-4529-B2AE-9C8DAED59F1B@.microsoft.com...
> I haven't seen how to do it using the .Net Framework, but if the method
you use for VB6 provides a COM object interface, you can include a reference
to the library in your project. .Net will create the classes required for
the mashalling between the managed and unmanaged code.|||Hi,
I've just tried your code fragment, and I don't get a problem.
Are you getting the problem in the debugger or deployed ?
Here are the facts for my set-up :-
VS 2003 / Framework 1.1
SQL Server 2000 SP3 (not Sp3a)
Windows 2000Pro SP4
Running via debugger, so not deployed.
Visual Basic Windows application
Option Explicit ON
Option Strict OFF
Option Compare Binary
The Imports and References are all the defaults for a Windows Application, e
xcepted added the SQLDMO Object lib version 8.0
Let me know how you get on|||If you're getting stuck, send me the source.
Email my Hotmail account, i'll send you my main email address.

Enumerate all available sql servers

Is there a possibility to enumerate all available sql servers in pure java.
At this time i execute osl -L and interprete the result.
Process p = runTime.exec("osql -L");
Computers without a msde or sql server installed do not have the osql
program. Is there a way to install osql? Or is there an other way to find all
available sql servers?
Thanks in advance Davy
You could simply try to connect to port 1433 of all machines and/or use
a JDBC driver that supports named pipes and try to connect via named
pipe to each machine in the network. This might take quite a while,
though.
Alin.
|||Thanks for the respond.
I already tried to connect to all machines, but i took a while (some minutes
which is too long).
I also tried to open a socket on port 1433, but sql server does not respond.
Is there a possibility to multicast a udp message to all ms-sql-monitors
(port 1434)?
Pipes is maybe an alternitive, but i'm not sure if pipes are enabled.
Davy
|||UDP port 1434 might just work. Give it a try and let me know how it
goes.
Alin.
|||Davy:
Rolling your own sqlbrowse with UDP on port 1434 should work, but if
you're considering going through OSQL then you'd be better off using
ODBC (SQLBrowseConnect) which is on every Windows box.
Be careful that this broadcast method is pretty imprecise -- Windows
machines after XPSP2 (esp. W2K3+) turn off port 1434 by default, and the
SQL Server 2005 will also ship with this port off by default for most
scenarios.
-shelby
Shelby Goerlitz
Microsoft SQL Server
"Davy" <Davy@.discussions.microsoft.com> wrote in message
news:Davy@.discussions.microsoft.com:
> Thanks for the respond.
> I already tried to connect to all machines, but i took a while (some
> minutes
> which is too long).
> I also tried to open a socket on port 1433, but sql server does not
> respond.
> Is there a possibility to multicast a udp message to all ms-sql-monitors
> (port 1434)?
> Pipes is maybe an alternitive, but i'm not sure if pipes are enabled.
> Davy
|||It’s quite difficult to find out the structure of the udp messages send by
the sql monitor. If anyone knows the udp structure all information is
welcome. I can try to write the udp messages with some help.
Davy
"Alin Sinpalean" schreef:

> UDP port 1434 might just work. Give it a try and let me know how it
> goes.
> Alin.
>
|||So it doesn’t seem a good idea?
I'll give it try, if someone has any idea which information to store in the
udp messages.
I tried the SQLBrowseConnect method as well. I couldn't call it directly
from java, but I found a C++ program.
http://www.sqldev.net/misc/ListSQLSvr.htm
It's easy to use from java and it uses the SQLBrowseConnect API, which is
osql independent.
Thank you very much
Davy
|||> I'll give it try, if someone has any idea which information to store
in the
> udp messages.
Just send a single 0x02 byte. You can find more info about the response
here [jTDS source code]:
http://cvs.sourceforge.net/viewcvs.p...=1.7&view=auto
Alin.
|||So, it's not even that difficult. I'm working on it, i hope to finish it
tomorrow. I'll post the result. Maybe one more question: any idea how to find
out the multicast address?
Right now i'm testing with a fixed 10.0.0.255 multicast address. Probably
this address want be te same for every company, but how can i calculate this
address?
Davy
"Alin Sinpalean" schreef:

> in the
> Just send a single 0x02 byte. You can find more info about the response
> here [jTDS source code]:
> http://cvs.sourceforge.net/viewcvs.p...=1.7&view=auto
> Alin.
>
|||Ok, i created some classes to look up all sql servers reachable by a
computer. The program performs a lookup of all subnets of a computer and send
the 02 multicast message on each subnet.
Where should i put the classes? Here as plain text on the forum?
To lookup the subnet of an ip, I use IPCONFIG. Ipconfig is translated, so I
included english, french and dutch. If you need more languages you should add
the texts. I'll add some comment to the source code.
Davy
"Alin Sinpalean" wrote:

> in the
> Just send a single 0x02 byte. You can find more info about the response
> here [jTDS source code]:
> http://cvs.sourceforge.net/viewcvs.p...=1.7&view=auto
> Alin.
>
sql

Enterprise vs Standard edition

Hello,
I installed sql server 2000 Enterprise edition on one of
my servers. It is currently being used. I found out today
that I was supposed to use Standard edition due to
licensing.
Is there any way to back down to Standard edition without
uninstalling and reinstalling?
Thanks
SteveHi,
No , you cant. Only way is to remove Enterprise edition and install Standard
edition. But the other way is possible.
THanks
Hari
MCDBA
"Steve" <ee07@.yahoo.com> wrote in message
news:cfcb01c48aa7$f19e4730$a401280a@.phx.gbl...
> Hello,
> I installed sql server 2000 Enterprise edition on one of
> my servers. It is currently being used. I found out today
> that I was supposed to use Standard edition due to
> licensing.
> Is there any way to back down to Standard edition without
> uninstalling and reinstalling?
> Thanks
> Steve|||Nope. You can upgrade from Standard to Enterprise, but you can't downgrade.
Uninstall and reinstall is the only way unfortunately. You can backup your
databases from Enterprise and restore them on Standard though.
--
Jacco Schalkwijk
SQL Server MVP
"Steve" <ee07@.yahoo.com> wrote in message
news:cfcb01c48aa7$f19e4730$a401280a@.phx.gbl...
> Hello,
> I installed sql server 2000 Enterprise edition on one of
> my servers. It is currently being used. I found out today
> that I was supposed to use Standard edition due to
> licensing.
> Is there any way to back down to Standard edition without
> uninstalling and reinstalling?
> Thanks
> Steve

Enterprise vs Standard edition

Hello,
I installed sql server 2000 Enterprise edition on one of
my servers. It is currently being used. I found out today
that I was supposed to use Standard edition due to
licensing.
Is there any way to back down to Standard edition without
uninstalling and reinstalling?
Thanks
Steve
Hi,
No , you cant. Only way is to remove Enterprise edition and install Standard
edition. But the other way is possible.
THanks
Hari
MCDBA
"Steve" <ee07@.yahoo.com> wrote in message
news:cfcb01c48aa7$f19e4730$a401280a@.phx.gbl...
> Hello,
> I installed sql server 2000 Enterprise edition on one of
> my servers. It is currently being used. I found out today
> that I was supposed to use Standard edition due to
> licensing.
> Is there any way to back down to Standard edition without
> uninstalling and reinstalling?
> Thanks
> Steve
|||Nope. You can upgrade from Standard to Enterprise, but you can't downgrade.
Uninstall and reinstall is the only way unfortunately. You can backup your
databases from Enterprise and restore them on Standard though.
Jacco Schalkwijk
SQL Server MVP
"Steve" <ee07@.yahoo.com> wrote in message
news:cfcb01c48aa7$f19e4730$a401280a@.phx.gbl...
> Hello,
> I installed sql server 2000 Enterprise edition on one of
> my servers. It is currently being used. I found out today
> that I was supposed to use Standard edition due to
> licensing.
> Is there any way to back down to Standard edition without
> uninstalling and reinstalling?
> Thanks
> Steve
sql

Enterprise vs Standard edition

Hello,
I installed sql server 2000 Enterprise edition on one of
my servers. It is currently being used. I found out today
that I was supposed to use Standard edition due to
licensing.
Is there any way to back down to Standard edition without
uninstalling and reinstalling?
Thanks
SteveHi,
No , you cant. Only way is to remove Enterprise edition and install Standard
edition. But the other way is possible.
THanks
Hari
MCDBA
"Steve" <ee07@.yahoo.com> wrote in message
news:cfcb01c48aa7$f19e4730$a401280a@.phx.gbl...
> Hello,
> I installed sql server 2000 Enterprise edition on one of
> my servers. It is currently being used. I found out today
> that I was supposed to use Standard edition due to
> licensing.
> Is there any way to back down to Standard edition without
> uninstalling and reinstalling?
> Thanks
> Steve|||Nope. You can upgrade from Standard to Enterprise, but you can't downgrade.
Uninstall and reinstall is the only way unfortunately. You can backup your
databases from Enterprise and restore them on Standard though.
Jacco Schalkwijk
SQL Server MVP
"Steve" <ee07@.yahoo.com> wrote in message
news:cfcb01c48aa7$f19e4730$a401280a@.phx.gbl...
> Hello,
> I installed sql server 2000 Enterprise edition on one of
> my servers. It is currently being used. I found out today
> that I was supposed to use Standard edition due to
> licensing.
> Is there any way to back down to Standard edition without
> uninstalling and reinstalling?
> Thanks
> Steve

Enterprise Reporting Services with Standard Edition SQL 2000

Hi
I am implementing Reporting Services and SQL Server on different servers ->
Server1: Reporting Services Enterprise Edition
Server2: SQL Server 2000 Standard Edition SP3a
Can I still use the Enterprise features of Reporting Services (specifically Data Driven Subscriptions), if the ReportServer database is implemented on a standard edition of SQL 2000?
Thanks,
MarkYou need an additional license for the additional server. In this case you
need SQL Server enterprise edition.
Erik
"Mark Barker" <MarkBarker@.discussions.microsoft.com> schreef in bericht
news:318E8A09-3241-4566-B3D7-85A2C93109FB@.microsoft.com...
> Hi
> I am implementing Reporting Services and SQL Server on different
servers ->
> Server1: Reporting Services Enterprise Edition
> Server2: SQL Server 2000 Standard Edition SP3a
> Can I still use the Enterprise features of Reporting Services
(specifically Data Driven Subscriptions), if the ReportServer database is
implemented on a standard edition of SQL 2000?
> Thanks,
> Mark
>|||Thanks Erik
I understand the licensing implications - What i was concerned about was functionality at the database layer - ie Will a ReportServer database implemented on standard edition (SQL Server) support data driven subscriptions from an enterprise edition of Reporting Services?
Thanks,
Mark
"Erik Tamminga" wrote:
> You need an additional license for the additional server. In this case you
> need SQL Server enterprise edition.
> Erik
> "Mark Barker" <MarkBarker@.discussions.microsoft.com> schreef in bericht
> news:318E8A09-3241-4566-B3D7-85A2C93109FB@.microsoft.com...
> > Hi
> >
> > I am implementing Reporting Services and SQL Server on different
> servers ->
> >
> > Server1: Reporting Services Enterprise Edition
> >
> > Server2: SQL Server 2000 Standard Edition SP3a
> >
> > Can I still use the Enterprise features of Reporting Services
> (specifically Data Driven Subscriptions), if the ReportServer database is
> implemented on a standard edition of SQL 2000?
> >
> > Thanks,
> > Mark
> >
>
>|||Yes, SQL and Reporting Services standard and enterprise SKUs can be mixed /
matched.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mark Barker" <MarkBarker@.discussions.microsoft.com> wrote in message
news:8B46132E-78D8-43F8-B0F0-AE70AF707A34@.microsoft.com...
> Thanks Erik
> I understand the licensing implications - What i was concerned about was
> functionality at the database layer - ie Will a ReportServer database
> implemented on standard edition (SQL Server) support data driven
> subscriptions from an enterprise edition of Reporting Services?
> Thanks,
> Mark
> "Erik Tamminga" wrote:
>> You need an additional license for the additional server. In this case
>> you
>> need SQL Server enterprise edition.
>> Erik
>> "Mark Barker" <MarkBarker@.discussions.microsoft.com> schreef in bericht
>> news:318E8A09-3241-4566-B3D7-85A2C93109FB@.microsoft.com...
>> > Hi
>> >
>> > I am implementing Reporting Services and SQL Server on different
>> servers ->
>> >
>> > Server1: Reporting Services Enterprise Edition
>> >
>> > Server2: SQL Server 2000 Standard Edition SP3a
>> >
>> > Can I still use the Enterprise features of Reporting Services
>> (specifically Data Driven Subscriptions), if the ReportServer database is
>> implemented on a standard edition of SQL 2000?
>> >
>> > Thanks,
>> > Mark
>> >
>>

Enterprise Manager version

Hello,
I noticed that the version of my Entrprise Manager does not reflect service pack 3a. When I right click on Microsoft SQL Servers below the Console Root tree and I select About Sql Server Entrprise Manager, it shows version 8.00.194. When I check Query An
alyzer in the Help Menu, I get the correct version of service pack 3a which is 8.00.760. I tried re-applying the service pack and rebooting and it still shows the incorrect version. Because of this, I am getting incorrect info through Taskpad View for the
correct table sizes in my database. Any ideas?
Thanks,
Nupee
> I noticed that the version of my Entrprise Manager does not reflect
service pack 3a. When I right click on Microsoft SQL Servers below the
Console Root tree and I select About Sql Server Entrprise Manager, it shows
version 8.00.194.
I only see Version 8.0, no .194 suffix.

> I am getting incorrect info through Taskpad View for the correct table
sizes in my database.
Why do you think this is because of your version? Try updating statistics
for the database.
http://www.aspfaq.com/
(Reverse address to reply.)
|||I forgot to mention that this is through my SQL Server 2000 client addition on my desktop. There is nothing wrong with the actual SQL Server. I seem to be the only one in my group experiencing this problem. I am currently using Windows XP professional. Da
tabase statistics have been updated and the result is the same.
"Aaron [SQL Server MVP]" wrote:

> service pack 3a. When I right click on Microsoft SQL Servers below the
> Console Root tree and I select About Sql Server Entrprise Manager, it shows
> version 8.00.194.
> I only see Version 8.0, no .194 suffix.
> sizes in my database.
> Why do you think this is because of your version? Try updating statistics
> for the database.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
|||Then you need to apply SP3 to your machine! But I still don't think that
will produce inaccurate table size results in the taskpad view. This is
because the statistics are out of date.
http://www.aspfaq.com/
(Reverse address to reply.)
"nupee" <nupee@.discussions.microsoft.com> wrote in message
news:D1FEBDD3-9DB0-446D-800B-622E44145AF2@.microsoft.com...
> I forgot to mention that this is through my SQL Server 2000 client
addition on my desktop. There is nothing wrong with the actual SQL Server. I
seem to be the only one in my group experiencing this problem. I am
currently using Windows XP professional. Database statistics have been
updated and the result is the same.
|||I have applied SP3 several times. Don't forget even without using Taskpad, when I check the version of my Entrprise Manager addition, it still does not reflect the SP3 being applied. I don't think this is a database issue. I think it's a SQL Client issue.
"Aaron [SQL Server MVP]" wrote:

> Then you need to apply SP3 to your machine! But I still don't think that
> will produce inaccurate table size results in the taskpad view. This is
> because the statistics are out of date.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "nupee" <nupee@.discussions.microsoft.com> wrote in message
> news:D1FEBDD3-9DB0-446D-800B-622E44145AF2@.microsoft.com...
> addition on my desktop. There is nothing wrong with the actual SQL Server. I
> seem to be the only one in my group experiencing this problem. I am
> currently using Windows XP professional. Database statistics have been
> updated and the result is the same.
>
>
|||> I have applied SP3 several times.
<sigh>
Is the client tools installation the *ONLY* instance of SQL Server you have
installed?
|||Yes that is the only instance. However, I do have reporting services loaded as well.
"Aaron [SQL Server MVP]" wrote:

> <sigh>
> Is the client tools installation the *ONLY* instance of SQL Server you have
> installed?
>
>
|||Just as an F.Y.I......I was able to resolve this problem by re-applying sp 3a using a dos prompt and running the setup.bat file. When I tried to apply the sp 3a through the setup.exe it didnot work. Strange Huh !!...Thanks away for your help.
"nupee" wrote:
[vbcol=seagreen]
> Yes that is the only instance. However, I do have reporting services loaded as well.
> "Aaron [SQL Server MVP]" wrote:

Enterprise Manager version

Hello,
I noticed that the version of my Entrprise Manager does not reflect service
pack 3a. When I right click on Microsoft SQL Servers below the Console Root
tree and I select About Sql Server Entrprise Manager, it shows version 8.00
.194. When I check Query An
alyzer in the Help Menu, I get the correct version of service pack 3a which
is 8.00.760. I tried re-applying the service pack and rebooting and it still
shows the incorrect version. Because of this, I am getting incorrect info t
hrough Taskpad View for the
correct table sizes in my database. Any ideas'
Thanks,
Nupee> I noticed that the version of my Entrprise Manager does not reflect
service pack 3a. When I right click on Microsoft SQL Servers below the
Console Root tree and I select About Sql Server Entrprise Manager, it shows
version 8.00.194.
I only see Version 8.0, no .194 suffix.

> I am getting incorrect info through Taskpad View for the correct table
sizes in my database.
Why do you think this is because of your version? Try updating statistics
for the database.
http://www.aspfaq.com/
(Reverse address to reply.)|||I forgot to mention that this is through my SQL Server 2000 client addition
on my desktop. There is nothing wrong with the actual SQL Server. I seem to
be the only one in my group experiencing this problem. I am currently using
Windows XP professional. Da
tabase statistics have been updated and the result is the same.
"Aaron [SQL Server MVP]" wrote:

> service pack 3a. When I right click on Microsoft SQL Servers below the
> Console Root tree and I select About Sql Server Entrprise Manager, it sho
ws
> version 8.00.194.
> I only see Version 8.0, no .194 suffix.
>
> sizes in my database.
> Why do you think this is because of your version? Try updating statistics
> for the database.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>|||Then you need to apply SP3 to your machine! But I still don't think that
will produce inaccurate table size results in the taskpad view. This is
because the statistics are out of date.
http://www.aspfaq.com/
(Reverse address to reply.)
"nupee" <nupee@.discussions.microsoft.com> wrote in message
news:D1FEBDD3-9DB0-446D-800B-622E44145AF2@.microsoft.com...
> I forgot to mention that this is through my SQL Server 2000 client
addition on my desktop. There is nothing wrong with the actual SQL Server. I
seem to be the only one in my group experiencing this problem. I am
currently using Windows XP professional. Database statistics have been
updated and the result is the same.|||I have applied SP3 several times. Don't forget even without using Taskpad, w
hen I check the version of my Entrprise Manager addition, it still does not
reflect the SP3 being applied. I don't think this is a database issue. I thi
nk it's a SQL Client issue.
"Aaron [SQL Server MVP]" wrote:

> Then you need to apply SP3 to your machine! But I still don't think that
> will produce inaccurate table size results in the taskpad view. This is
> because the statistics are out of date.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "nupee" <nupee@.discussions.microsoft.com> wrote in message
> news:D1FEBDD3-9DB0-446D-800B-622E44145AF2@.microsoft.com...
> addition on my desktop. There is nothing wrong with the actual SQL Server.
I
> seem to be the only one in my group experiencing this problem. I am
> currently using Windows XP professional. Database statistics have been
> updated and the result is the same.
>
>|||> I have applied SP3 several times.
<sigh>
Is the client tools installation the *ONLY* instance of SQL Server you have
installed?|||Yes that is the only instance. However, I do have reporting services loaded
as well.
"Aaron [SQL Server MVP]" wrote:

> <sigh>
> Is the client tools installation the *ONLY* instance of SQL Server you hav
e
> installed?
>
>|||Just as an F.Y.I......I was able to resolve this problem by re-applying sp
3a using a dos prompt and running the setup.bat file. When I tried to apply
the sp 3a through the setup.exe it didnot work. Strange Huh !!...Thanks aw
ay for your help.
"nupee" wrote:
[vbcol=seagreen]
> Yes that is the only instance. However, I do have reporting services loade
d as well.
> "Aaron [SQL Server MVP]" wrote:
>

Enterprise Manager Unknown Error

I am running SQL2000 sp3 with 819 hotfix on a 2003
Cluster. When I am on one of the database servers in the
cluster I can select from a table and get data returned.
When I am on the webserver and use EnterPrise I can see
the tables but when I try to select I get 'Unknown Error'.
The same select works from ISQL/W GUI and isql at the
command line while on the webserver.
Any ideas on what to look for would be helpful, nothing is
being logged in the eventlog or the sql log.
Thanks
Check the following;
- The MDAC version on the good and the bad machine. If possible upgrade to
the latest version of MDAC
- Capture the T-SQL command from profiler while you are try to retrieve the
data and see if you can identify the issue.
- Permissions
- The client configuration options by comparing them to the good machine.
HTH
SQL Server Support
Agnes Panosian

Enterprise Manager Shortcuts for Remote Servers

Hello and thank you in advance.
I have multiple databases on a single remote MSSQL server (from my ISP). I
can only access them via Enterprise Manager. My quandary is that every time
I log in, I have to click the server name, then wait for the database to
load, then sift through this enormous list to find the database I am seeking.
I'd like to have shortcuts to each specific database so I can connect and
get to the tables with one click.
Anyone know how to do this?
Thanks,
JulianHi Julian,
Do you have restriction for using Query Analyzer also? If not, while
configuring the client ODBC, you can specify the default database you wish to
connect to.
--
Thanks
Yogish|||Thank you for your reply. I don't think I have a restriction for Query
Analyzer, but I am a novice at best and am only barely qualified to use
Enterprise Manager.
Does this mean I'd have to switch to Query Analyzer or are you suggesting
that I can use Query Analyzer to store my default database and somehow tie
that back to using Enterprise Manager? It puzzles me why Enterprise Manager
doesn't allow you to store a default database for each SQL Server
Registration.
"Yogish" wrote:
> Hi Julian,
> Do you have restriction for using Query Analyzer also? If not, while
> configuring the client ODBC, you can specify the default database you wish to
> connect to.
> --
> Thanks
> Yogish|||Hi Julian,
You can do lot of operations with Query Analyzer (QA). If you are using SQL
Server 2000 client, you can use Object Browser to access all the database
objects, provided you have the permission.
Check out Books online.
--
Thanks
Yogish

Enterprise Manager Shortcuts for Remote Servers

Hello and thank you in advance.
I have multiple databases on a single remote MSSQL server (from my ISP). I
can only access them via Enterprise Manager. My quandary is that every time
I log in, I have to click the server name, then wait for the database to
load, then sift through this enormous list to find the database I am seeking.
I'd like to have shortcuts to each specific database so I can connect and
get to the tables with one click.
Anyone know how to do this?
Thanks,
Julian
Hi Julian,
Do you have restriction for using Query Analyzer also? If not, while
configuring the client ODBC, you can specify the default database you wish to
connect to.
Thanks
Yogish
|||Thank you for your reply. I don't think I have a restriction for Query
Analyzer, but I am a novice at best and am only barely qualified to use
Enterprise Manager.
Does this mean I'd have to switch to Query Analyzer or are you suggesting
that I can use Query Analyzer to store my default database and somehow tie
that back to using Enterprise Manager? It puzzles me why Enterprise Manager
doesn't allow you to store a default database for each SQL Server
Registration.
"Yogish" wrote:

> Hi Julian,
> Do you have restriction for using Query Analyzer also? If not, while
> configuring the client ODBC, you can specify the default database you wish to
> connect to.
> --
> Thanks
> Yogish
|||Hi Julian,
You can do lot of operations with Query Analyzer (QA). If you are using SQL
Server 2000 client, you can use Object Browser to access all the database
objects, provided you have the permission.
Check out Books online.
Thanks
Yogish

Enterprise Manager Shortcuts for Remote Servers

Hello and thank you in advance.
I have multiple databases on a single remote MSSQL server (from my ISP). I
can only access them via Enterprise Manager. My quandary is that every time
I log in, I have to click the server name, then wait for the database to
load, then sift through this enormous list to find the database I am seeking
.
I'd like to have shortcuts to each specific database so I can connect and
get to the tables with one click.
Anyone know how to do this?
Thanks,
JulianHi Julian,
Do you have restriction for using Query Analyzer also? If not, while
configuring the client ODBC, you can specify the default database you wish t
o
connect to.
Thanks
Yogish|||Thank you for your reply. I don't think I have a restriction for Query
Analyzer, but I am a novice at best and am only barely qualified to use
Enterprise Manager.
Does this mean I'd have to switch to Query Analyzer or are you suggesting
that I can use Query Analyzer to store my default database and somehow tie
that back to using Enterprise Manager? It puzzles me why Enterprise Manager
doesn't allow you to store a default database for each SQL Server
Registration.
"Yogish" wrote:

> Hi Julian,
> Do you have restriction for using Query Analyzer also? If not, while
> configuring the client ODBC, you can specify the default database you wish
to
> connect to.
> --
> Thanks
> Yogish|||Hi Julian,
You can do lot of operations with Query Analyzer (QA). If you are using SQL
Server 2000 client, you can use Object Browser to access all the database
objects, provided you have the permission.
Check out Books online.
Thanks
Yogish

Enterprise Manager Server Registration General Network Error

I'm having problems Registering servers in Enterrpise Manager.
This problem is workstation specific.
Workstation is XP Pro SP1, in an Active Directory domain. Only protocol in
machine is TCP/IP.
I have 4 machines with identical hardware ghosted from one source image and
all have the problem. hardware isn't the problem. I have at least one
other Win XP Pro computer built from a different build that has the problem.
User logs on using Active Driectory account. Opens Enterprise Manager,
register SQL server, types server name, uses NT Authentication. Error
returned is "General Network Error, check you network documentation"
Registration using SQL Authentication works fine (using SQL Authentication
is NOT an option for security reasons)
Same user can perform the same task using the same Active Directory
credentials using a different machine, so the account is not the problem.
This machine has different hardware, runs Windows 2000 Pro.
I can use this Windows 2000 machine on the same network port that the other
machine is on and don't have a problem. The network from the NIC to the
server isn't the problem.
I tried updating MDAC from 2.7 to 2.8 with no change.
SQL Server in question is newly build SQL 2000 SP3a with NO load on it
(application vendor hasn't installed software yet).
Query Analyzer has the same problem.
I tried using ODBCPING.EXE and received this response:
COULD NOT CONNECT TO SQL SERVER
SQLState: 08S01 Native Error: 11
Info. Message: [Microsoft][ODBC SQL Server Driver][DBNETLIB]Gene
ral network
error. Check your network documentation.
SQLState: 01000 Native Error: 10054
Info. Message: [Microsoft][ODBC SQL Server Driver][DBNETLIB]Conn
ectionRead
(recv()).
A similar error came up from Query Analyzer.
I did find 2 different SQL servers that will allow registrations, but these
users don't need access to those servers.
What do I need to look at on this client to correct this problem?
Scott Beginkb below has some good troubleshooting steps
http://support.microsoft.com/defaul...kb;en-us;827422
Andy.
"Scott Begin" <ScottBegin@.discussions.microsoft.com> wrote in message
news:3CF7A011-A316-493B-9EFB-D45434373BCF@.microsoft.com...
> I'm having problems Registering servers in Enterrpise Manager.
> This problem is workstation specific.
> Workstation is XP Pro SP1, in an Active Directory domain. Only protocol
> in
> machine is TCP/IP.
> I have 4 machines with identical hardware ghosted from one source image
> and
> all have the problem. hardware isn't the problem. I have at least one
> other Win XP Pro computer built from a different build that has the
> problem.
> User logs on using Active Driectory account. Opens Enterprise Manager,
> register SQL server, types server name, uses NT Authentication. Error
> returned is "General Network Error, check you network documentation"
> Registration using SQL Authentication works fine (using SQL Authentication
> is NOT an option for security reasons)
> Same user can perform the same task using the same Active Directory
> credentials using a different machine, so the account is not the problem.
> This machine has different hardware, runs Windows 2000 Pro.
> I can use this Windows 2000 machine on the same network port that the
> other
> machine is on and don't have a problem. The network from the NIC to the
> server isn't the problem.
> I tried updating MDAC from 2.7 to 2.8 with no change.
> SQL Server in question is newly build SQL 2000 SP3a with NO load on it
> (application vendor hasn't installed software yet).
> Query Analyzer has the same problem.
> I tried using ODBCPING.EXE and received this response:
>
> COULD NOT CONNECT TO SQL SERVER
> SQLState: 08S01 Native Error: 11
> Info. Message: [Microsoft][ODBC SQL Server Driver][DBNETLIB]Ge
neral
> network
> error. Check your network documentation.
> SQLState: 01000 Native Error: 10054
> Info. Message: [Microsoft][ODBC SQL Server Driver][DBNETLIB]Co
nnectionRead
> (recv()).
> A similar error came up from Query Analyzer.
> I did find 2 different SQL servers that will allow registrations, but
> these
> users don't need access to those servers.
> What do I need to look at on this client to correct this problem?
> Scott Begin
>
>
>|||I looked at the article
I've tried the suggestions listed, but with no luck
1) Check DNS.
I can ping the server by name from the affected client. (rules out name
resolution)
I can register the server by name using SQL Authentication (rules out name
resolution)
I can register the server by IP address (rules out name resolution)
2) Verify the enabled protocols and aliases
Working Windows 2000 machine has Named Pipes and TCP/IP configured. Not
working XP machine matches. No aliases defined on either machine.
Everything else in Client Network Utility is the same on both machines.
3) Verify that the instance of SQL Server is listening Correctly
Have working Windows 2000 machine that can connect to this instance of SQL
Server using NT Authentication. XP Machine can connect to this instance of
SQL Server using SQL Authentication but NOT NT Authentication. As Suggested
by the article, the SQL Server log shows it is listening on port 1433
correctly.
Instance is running correctly.
4) Troubleshoot MDAC Issues
Windows 2000 Pro machine that works is running MDAC 2.7 SP1 Refresh
Windows XP Machine that doesn't work is running MDAC 2.8 RTM
ODBC Ping on 2000 machine that works shows the connection is being opened
properly.
ODBC Ping on XP machine that doesn't shows the following errors:
COULD NOT CONNECT TO SQL SERVER
SQLState: 08S01 Native Error: 11
Info. Message: [Microsoft][ODBC SQL Server Driver][DBNETLIB]Gene
ral network
error. Check your network documentation.
SQLState: 01000 Native Error: 10054
Info. Message: [Microsoft][ODBC SQL Server Driver][DBNETLIB]Conn
ectionRead
(recv()).
Seems to be an ODBC Issue
5) Troubleshoot firewall Issues:
Not applicable. There isn't a firewall between the client and server.
6) Troubleshoot Authentication and Security Issues
I use Active Directory Account on Windows 2000 machine. NT Authentication
works. I use same Active Directory account on Windows XP machine, doesn't
work.
Problem isn't authentication / security
7) Troubleshoot Stress on TCP/IP sockets
One of the servers being connected is a new server, without an application
running on it I don't think the stress on the TCP/IP sockets is the issue
8) See if teh instance of SQL Server is started in single user mode
I can connect to the server from other workstations simultaneously, so this
isn't the problem
9) Verify Named Pipes connectivity to SQL Server
Not trying to use Named Pipes to connect.
10) Troubleshoot conenctions that time otu during the recovery process.
These servers have been running anywhere from 1 day to 4 months. Recovery
process isn't going on. If this were a problem, I couldn't connect from th
e
Windows 2000 machine.
11) Test different ways to connect to the instance of SQL Server
Use SQL Authentication: Works from affected machine
From other data sources: Enterprise manager Fails NT Authentication, works
SQL; ODBC fails NT authentication, works SQL; Query Analyzer fails NT
Authentication, works SQL;
Using other protocols: Not an option. Must use TCP/IP
Different Login Account: why? The login account works on another computer
Put entry in hosts file: Why, resolution not problem
Connect from SQL Server: Works
Connect using IP address: Fails NT Authenticatiion/ works SQL Authenticatio
n
Specify port: Why? This doesn't seem to be the problem
12) Capture Network Traces:
Haven't tried this
The recurring theme you should see in what I have done is NT Authentication
doesn't work from this client. SQL Authentication does work from this
client. There is some setting / Driver or something that prevents it from
working.
Any other Ideas?
Scott Begin
scott@.thebegins.com
"Andy Ball" wrote:

> kb below has some good troubleshooting steps
> http://support.microsoft.com/defaul...kb;en-us;827422
> Andy.
> "Scott Begin" <ScottBegin@.discussions.microsoft.com> wrote in message
> news:3CF7A011-A316-493B-9EFB-D45434373BCF@.microsoft.com...
>
>

Enterprise Manager Server Registration General Network Error

I'm having problems Registering servers in Enterrpise Manager.
This problem is workstation specific.
Workstation is XP Pro SP1, in an Active Directory domain. Only protocol in
machine is TCP/IP.
I have 4 machines with identical hardware ghosted from one source image and
all have the problem. Hardware isn't the problem. I have at least one
other Win XP Pro computer built from a different build that has the problem.
User logs on using Active Driectory account. Opens Enterprise Manager,
register SQL server, types server name, uses NT Authentication. Error
returned is "General Network Error, check you network documentation"
Registration using SQL Authentication works fine (using SQL Authentication
is NOT an option for security reasons)
Same user can perform the same task using the same Active Directory
credentials using a different machine, so the account is not the problem.
This machine has different hardware, runs Windows 2000 Pro.
I can use this Windows 2000 machine on the same network port that the other
machine is on and don't have a problem. The network from the NIC to the
server isn't the problem.
I tried updating MDAC from 2.7 to 2.8 with no change.
SQL Server in question is newly build SQL 2000 SP3a with NO load on it
(application vendor hasn't installed software yet).
Query Analyzer has the same problem.
I tried using ODBCPING.EXE and received this response:
COULD NOT CONNECT TO SQL SERVER
SQLState: 08S01 Native Error: 11
Info. Message: [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network
error. Check your network documentation.
SQLState: 01000 Native Error: 10054
Info. Message: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead
(recv()).
A similar error came up from Query Analyzer.
I did find 2 different SQL servers that will allow registrations, but these
users don't need access to those servers.
What do I need to look at on this client to correct this problem?
Scott Begin
kb below has some good troubleshooting steps
http://support.microsoft.com/default...b;en-us;827422
Andy.
"Scott Begin" <ScottBegin@.discussions.microsoft.com> wrote in message
news:3CF7A011-A316-493B-9EFB-D45434373BCF@.microsoft.com...
> I'm having problems Registering servers in Enterrpise Manager.
> This problem is workstation specific.
> Workstation is XP Pro SP1, in an Active Directory domain. Only protocol
> in
> machine is TCP/IP.
> I have 4 machines with identical hardware ghosted from one source image
> and
> all have the problem. Hardware isn't the problem. I have at least one
> other Win XP Pro computer built from a different build that has the
> problem.
> User logs on using Active Driectory account. Opens Enterprise Manager,
> register SQL server, types server name, uses NT Authentication. Error
> returned is "General Network Error, check you network documentation"
> Registration using SQL Authentication works fine (using SQL Authentication
> is NOT an option for security reasons)
> Same user can perform the same task using the same Active Directory
> credentials using a different machine, so the account is not the problem.
> This machine has different hardware, runs Windows 2000 Pro.
> I can use this Windows 2000 machine on the same network port that the
> other
> machine is on and don't have a problem. The network from the NIC to the
> server isn't the problem.
> I tried updating MDAC from 2.7 to 2.8 with no change.
> SQL Server in question is newly build SQL 2000 SP3a with NO load on it
> (application vendor hasn't installed software yet).
> Query Analyzer has the same problem.
> I tried using ODBCPING.EXE and received this response:
>
> COULD NOT CONNECT TO SQL SERVER
> SQLState: 08S01 Native Error: 11
> Info. Message: [Microsoft][ODBC SQL Server Driver][DBNETLIB]General
> network
> error. Check your network documentation.
> SQLState: 01000 Native Error: 10054
> Info. Message: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead
> (recv()).
> A similar error came up from Query Analyzer.
> I did find 2 different SQL servers that will allow registrations, but
> these
> users don't need access to those servers.
> What do I need to look at on this client to correct this problem?
> Scott Begin
>
>
>
|||I looked at the article
I've tried the suggestions listed, but with no luck
1) Check DNS.
I can ping the server by name from the affected client. (rules out name
resolution)
I can register the server by name using SQL Authentication (rules out name
resolution)
I can register the server by IP address (rules out name resolution)
2) Verify the enabled protocols and aliases
Working Windows 2000 machine has Named Pipes and TCP/IP configured. Not
working XP machine matches. No aliases defined on either machine.
Everything else in Client Network Utility is the same on both machines.
3) Verify that the instance of SQL Server is listening Correctly
Have working Windows 2000 machine that can connect to this instance of SQL
Server using NT Authentication. XP Machine can connect to this instance of
SQL Server using SQL Authentication but NOT NT Authentication. As Suggested
by the article, the SQL Server log shows it is listening on port 1433
correctly.
Instance is running correctly.
4) Troubleshoot MDAC Issues
Windows 2000 Pro machine that works is running MDAC 2.7 SP1 Refresh
Windows XP Machine that doesn't work is running MDAC 2.8 RTM
ODBC Ping on 2000 machine that works shows the connection is being opened
properly.
ODBC Ping on XP machine that doesn't shows the following errors:
COULD NOT CONNECT TO SQL SERVER
SQLState: 08S01 Native Error: 11
Info. Message: [Microsoft][ODBC SQL Server Driver][DBNETLIB]General network
error. Check your network documentation.
SQLState: 01000 Native Error: 10054
Info. Message: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead
(recv()).
Seems to be an ODBC Issue
5) Troubleshoot firewall Issues:
Not applicable. There isn't a firewall between the client and server.
6) Troubleshoot Authentication and Security Issues
I use Active Directory Account on Windows 2000 machine. NT Authentication
works. I use same Active Directory account on Windows XP machine, doesn't
work.
Problem isn't authentication / security
7) Troubleshoot Stress on TCP/IP sockets
One of the servers being connected is a new server, without an application
running on it I don't think the stress on the TCP/IP sockets is the issue
8) See if teh instance of SQL Server is started in single user mode
I can connect to the server from other workstations simultaneously, so this
isn't the problem
9) Verify Named Pipes connectivity to SQL Server
Not trying to use Named Pipes to connect.
10) Troubleshoot conenctions that time otu during the recovery process.
These servers have been running anywhere from 1 day to 4 months. Recovery
process isn't going on. If this were a problem, I couldn't connect from the
Windows 2000 machine.
11) Test different ways to connect to the instance of SQL Server
Use SQL Authentication: Works from affected machine
From other data sources: Enterprise manager Fails NT Authentication, works
SQL; ODBC fails NT authentication, works SQL; Query Analyzer fails NT
Authentication, works SQL;
Using other protocols: Not an option. Must use TCP/IP
Different Login Account: why? The login account works on another computer
Put entry in hosts file: Why, resolution not problem
Connect from SQL Server: Works
Connect using IP address: Fails NT Authenticatiion/ works SQL Authentication
Specify port: Why? This doesn't seem to be the problem
12) Capture Network Traces:
Haven't tried this
The recurring theme you should see in what I have done is NT Authentication
doesn't work from this client. SQL Authentication does work from this
client. There is some setting / Driver or something that prevents it from
working.
Any other Ideas?
Scott Begin
scott@.thebegins.com
"Andy Ball" wrote:

> kb below has some good troubleshooting steps
> http://support.microsoft.com/default...b;en-us;827422
> Andy.
> "Scott Begin" <ScottBegin@.discussions.microsoft.com> wrote in message
> news:3CF7A011-A316-493B-9EFB-D45434373BCF@.microsoft.com...
>
>

Enterprise manager query timeout

When I check the server's query timeout on the Server properties /
Connections tab in enterprise manager, it is set to 600 seconds.
Yet when I run a complicated query, it times out after 40 seconds.
The same query takes about a minute in OSQL, and succeeds there.
Is there an additional time-out that EM imposes, and can it be changed?
"Lucvdv" <replace_name@.null.net> wrote in message
news:kpjgh1lgjsqe3boeredlvn7iu5ipr3dp2k@.4ax.com...
> When I check the server's query timeout on the Server properties /
> Connections tab in enterprise manager, it is set to 600 seconds.
> Yet when I run a complicated query, it times out after 40 seconds.
> The same query takes about a minute in OSQL, and succeeds there.
> Is there an additional time-out that EM imposes, and can it be
> changed?
I believe this is a known issue. You should use Query Analyzer for all
your querying rather than going through SQL EM. This problem may have
been addressed in the recent SQL Server service pack (not sure). What SP
are you running on the client?
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||On Fri, 2 Sep 2005 10:34:38 -0400, "David Gugick"
<david.gugick-nospam@.quest.com> wrote:

> "Lucvdv" <replace_name@.null.net> wrote in message
> news:kpjgh1lgjsqe3boeredlvn7iu5ipr3dp2k@.4ax.com...
> I believe this is a known issue. You should use Query Analyzer for all
> your querying rather than going through SQL EM. This problem may have
> been addressed in the recent SQL Server service pack (not sure). What SP
> are you running on the client?
Still SP3 on server and client.
I haven't downloaded SP4 yet because it looked like the changes are mostly
intended for 64 bit systems, I decided to wait until I get it through MSDN.
I'll take your advice and use Query Analyzer.
|||First of all the query time-out setting on the connections tab is only
for remote server queries. From what I understand your running a local
query.
The problem is that EM as a client application has it's own timeout
configuration setting which I admit is rather short. Query Analyzer on
the other hand by default waits as long as it needs, so you won't get
any timeout.
M
|||On 5 Sep 2005 01:03:31 -0700, m.bohse@.quest-consultants.com wrote:

> First of all the query time-out setting on the connections tab is only
> for remote server queries. From what I understand your running a local
> query.
> The problem is that EM as a client application has it's own timeout
> configuration setting which I admit is rather short. Query Analyzer on
> the other hand by default waits as long as it needs, so you won't get
> any timeout.
I found the setting, Tools -> Options -> Advanced -> Connection settings,
the default is 0 = infinite (says online help).
Trying to override it (I set it to 600 seconds) makes no difference.
I upgraded to SP4, and it's still the same

Enterprise Manager Hangs

Our company recently moved to a corporate Windows 2000 Network and AD
from Novell and all our servers were moved from our little domain. We
are seeing a wierd problem with SQLSever since our move. The sever that
has SQL Server is working fine and we are able to register the server in
Enterprise Manager. However, it sits and hangs when trying to browse
the Databases or Management nodes (all other nodes are ok). We can also
get to Query Analyzer and queries against any of the the database tables
work just fine .. UNLESS Query Analyzer tries to browse for the
databases (to populate that database dropdown or display the Object
browser) .. in that case, it sits and hangs.
We have installed Service Pack 4 and this did not resolve the issue.
The hotfix for RAM over 2 gig on the server does not apply in our case.
Has anyone experienced this problem before? We rebooted SQL Server
yesterday and after a couple of reboots, it worked (the Query Analyzer
issue remained), but we are now back to the same issue.
Any clues, suggestions, and of course fixes would be much appreciated!
Thank you!
Artie
*** Sent via Developersdex http://www.codecomments.com ***
Can you try executing this sp from QA and tell us how much time it takes?
exec master.dbo.sp_MShasdbaccess
AMB
"Art" wrote:

> Our company recently moved to a corporate Windows 2000 Network and AD
> from Novell and all our servers were moved from our little domain. We
> are seeing a wierd problem with SQLSever since our move. The sever that
> has SQL Server is working fine and we are able to register the server in
> Enterprise Manager. However, it sits and hangs when trying to browse
> the Databases or Management nodes (all other nodes are ok). We can also
> get to Query Analyzer and queries against any of the the database tables
> work just fine .. UNLESS Query Analyzer tries to browse for the
> databases (to populate that database dropdown or display the Object
> browser) .. in that case, it sits and hangs.
> We have installed Service Pack 4 and this did not resolve the issue.
> The hotfix for RAM over 2 gig on the server does not apply in our case.
> Has anyone experienced this problem before? We rebooted SQL Server
> yesterday and after a couple of reboots, it worked (the Query Analyzer
> issue remained), but we are now back to the same issue.
> Any clues, suggestions, and of course fixes would be much appreciated!
> Thank you!
> Artie
>
> *** Sent via Developersdex http://www.codecomments.com ***
>
|||Alejandro,
"exec master.dbo.sp_MShasdbaccess" has been churning for 2 minutes now
with no result. Hope this means that the plot thickens! Thanks for
your help!
Artie
*** Sent via Developersdex http://www.codecomments.com ***
|||" minutes seems to be a long time. Do you have many databases? Do you have autoclose turned on?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Art" <anonymousnospam@.devex.com> wrote in message news:uZrgpiHjFHA.1464@.TK2MSFTNGP14.phx.gbl...
> Alejandro,
> "exec master.dbo.sp_MShasdbaccess" has been churning for 2 minutes now
> with no result. Hope this means that the plot thickens! Thanks for
> your help!
> Artie
> *** Sent via Developersdex http://www.codecomments.com ***
|||We have about 20 databases. Thing is, we had absolutely no problems
until we moved to this new environment (Windows / AD) a few days ago -
Looks like this may be an access/permissions issue? I looked at the
autoclose option for a couple of the databases on the server and looks
like it is false (I used SELECT DATABASEPROPERTYEX('<DBNAME>',
'IsAutoClose')).
Thank you!
Artie
*** Sent via Developersdex http://www.codecomments.com ***
|||Hi,
If the owner of one of your databases is an AD account, it may cause the
problem. Set "sa" as the owner of all of your DBs
Erdal
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uGbVkrHjFHA.3316@.TK2MSFTNGP14.phx.gbl...
> " minutes seems to be a long time. Do you have many databases? Do you have
autoclose turned on?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Art" <anonymousnospam@.devex.com> wrote in message
news:uZrgpiHjFHA.1464@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
|||Normally, I would suspect ODBC tracing turned on at the client machine, but the fact that the query
also ran slow using QA got me suspicious. Perhaps you can run that query from QA again and use
Profiler to trace the statements inside that procedure to see which takes a long time?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Art" <anonymousnospam@.devex.com> wrote in message news:%23KeceaIjFHA.3316@.TK2MSFTNGP14.phx.gbl...
> We have about 20 databases. Thing is, we had absolutely no problems
> until we moved to this new environment (Windows / AD) a few days ago -
> Looks like this may be an access/permissions issue? I looked at the
> autoclose option for a couple of the databases on the server and looks
> like it is false (I used SELECT DATABASEPROPERTYEX('<DBNAME>',
> 'IsAutoClose')).
> Thank you!
> Artie
>
> *** Sent via Developersdex http://www.codecomments.com ***
|||May be what Erdal is saying, is what is hurting the sp. Try executing the
only statement inside the sp [sp_mshasdbaccess] and you will get same
problem, but if you comment the line:
--owner = substring(suser_sname(sid), 1, 24),
then everything will be normal.
Try reporting this to Microsoft.
AMB
"Art" wrote:

> We have about 20 databases. Thing is, we had absolutely no problems
> until we moved to this new environment (Windows / AD) a few days ago -
> Looks like this may be an access/permissions issue? I looked at the
> autoclose option for a couple of the databases on the server and looks
> like it is false (I used SELECT DATABASEPROPERTYEX('<DBNAME>',
> 'IsAutoClose')).
> Thank you!
> Artie
>
> *** Sent via Developersdex http://www.codecomments.com ***
>
|||Tibor
sp_MsHasDbAccess does not return any result at all .. it simply hangs.
So when I ran profiler while trying to execute it, it shows a bunch of
stuff under my login name and then sits on sp_MsHasDbAccess. (btw, some
of the statements before that was select IS_SRVROLEMEMBER ('sysadmin'),
which returns a 1; SELECT ISNULL(SUSER_SNAME(), SUSER_NAME()) correctly
returns my login name).
Thanks!
Aarti
*** Sent via Developersdex http://www.codecomments.com ***
|||I was referring to tracing the TSQL code *inside* MsHasDbAccess. You need to capture the right
events for this. See Alejandro's most recent post in this thread.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Art" <anonymousnospam@.devex.com> wrote in message news:%23gP7y1IjFHA.1412@.TK2MSFTNGP09.phx.gbl...
> Tibor
> sp_MsHasDbAccess does not return any result at all .. it simply hangs.
> So when I ran profiler while trying to execute it, it shows a bunch of
> stuff under my login name and then sits on sp_MsHasDbAccess. (btw, some
> of the statements before that was select IS_SRVROLEMEMBER ('sysadmin'),
> which returns a 1; SELECT ISNULL(SUSER_SNAME(), SUSER_NAME()) correctly
> returns my login name).
> Thanks!
> Aarti
>
> *** Sent via Developersdex http://www.codecomments.com ***
>

Enterprise Manager Hangs

Our company recently moved to a corporate Windows 2000 Network and AD
from Novell and all our servers were moved from our little domain. We
are seeing a wierd problem with SQLSever since our move. The sever that
has SQL Server is working fine and we are able to register the server in
Enterprise Manager. However, it sits and hangs when trying to browse
the Databases or Management nodes (all other nodes are ok). We can also
get to Query Analyzer and queries against any of the the database tables
work just fine .. UNLESS Query Analyzer tries to browse for the
databases (to populate that database dropdown or display the Object
browser) .. in that case, it sits and hangs.
We have installed Service Pack 4 and this did not resolve the issue.
The hotfix for RAM over 2 gig on the server does not apply in our case.
Has anyone experienced this problem before? We rebooted SQL Server
yesterday and after a couple of reboots, it worked (the Query Analyzer
issue remained), but we are now back to the same issue.
Any clues, suggestions, and of course fixes would be much appreciated!
Thank you!
Artie
*** Sent via Developersdex http://www.codecomments.com ***Can you try executing this sp from QA and tell us how much time it takes?
exec master.dbo.sp_MShasdbaccess
AMB
"Art" wrote:

> Our company recently moved to a corporate Windows 2000 Network and AD
> from Novell and all our servers were moved from our little domain. We
> are seeing a wierd problem with SQLSever since our move. The sever that
> has SQL Server is working fine and we are able to register the server in
> Enterprise Manager. However, it sits and hangs when trying to browse
> the Databases or Management nodes (all other nodes are ok). We can also
> get to Query Analyzer and queries against any of the the database tables
> work just fine .. UNLESS Query Analyzer tries to browse for the
> databases (to populate that database dropdown or display the Object
> browser) .. in that case, it sits and hangs.
> We have installed Service Pack 4 and this did not resolve the issue.
> The hotfix for RAM over 2 gig on the server does not apply in our case.
> Has anyone experienced this problem before? We rebooted SQL Server
> yesterday and after a couple of reboots, it worked (the Query Analyzer
> issue remained), but we are now back to the same issue.
> Any clues, suggestions, and of course fixes would be much appreciated!
> Thank you!
> Artie
>
> *** Sent via Developersdex http://www.codecomments.com ***
>|||Alejandro,
"exec master.dbo.sp_MShasdbaccess" has been churning for 2 minutes now
with no result. Hope this means that the plot thickens! Thanks for
your help!
Artie
*** Sent via Developersdex http://www.codecomments.com ***|||" minutes seems to be a long time. Do you have many databases? Do you have a
utoclose turned on?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Art" <anonymousnospam@.devex.com> wrote in message news:uZrgpiHjFHA.1464@.TK2MSFTNGP14.phx.gb
l...
> Alejandro,
> "exec master.dbo.sp_MShasdbaccess" has been churning for 2 minutes now
> with no result. Hope this means that the plot thickens! Thanks for
> your help!
> Artie
> *** Sent via Developersdex http://www.codecomments.com ***|||We have about 20 databases. Thing is, we had absolutely no problems
until we moved to this new environment (Windows / AD) a few days ago -
Looks like this may be an access/permissions issue? I looked at the
autoclose option for a couple of the databases on the server and looks
like it is false (I used SELECT DATABASEPROPERTYEX('<DBNAME>',
'IsAutoClose')).
Thank you!
Artie
*** Sent via Developersdex http://www.codecomments.com ***|||Hi,
If the owner of one of your databases is an AD account, it may cause the
problem. Set "sa" as the owner of all of your DBs
Erdal
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uGbVkrHjFHA.3316@.TK2MSFTNGP14.phx.gbl...
> " minutes seems to be a long time. Do you have many databases? Do you have
autoclose turned on?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Art" <anonymousnospam@.devex.com> wrote in message
news:uZrgpiHjFHA.1464@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]|||Normally, I would suspect ODBC tracing turned on at the client machine, but
the fact that the query
also ran slow using QA got me suspicious. Perhaps you can run that query fro
m QA again and use
Profiler to trace the statements inside that procedure to see which takes a
long time?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Art" <anonymousnospam@.devex.com> wrote in message news:%23KeceaIjFHA.3316@.TK2MSFTNGP14.phx.
gbl...
> We have about 20 databases. Thing is, we had absolutely no problems
> until we moved to this new environment (Windows / AD) a few days ago -
> Looks like this may be an access/permissions issue? I looked at the
> autoclose option for a couple of the databases on the server and looks
> like it is false (I used SELECT DATABASEPROPERTYEX('<DBNAME>',
> 'IsAutoClose')).
> Thank you!
> Artie
>
> *** Sent via Developersdex http://www.codecomments.com ***|||May be what Erdal is saying, is what is hurting the sp. Try executing the
only statement inside the sp [sp_mshasdbaccess] and you will get same
problem, but if you comment the line:
-- owner = substring(suser_sname(sid), 1, 24),
then everything will be normal.
Try reporting this to Microsoft.
AMB
"Art" wrote:

> We have about 20 databases. Thing is, we had absolutely no problems
> until we moved to this new environment (Windows / AD) a few days ago -
> Looks like this may be an access/permissions issue? I looked at the
> autoclose option for a couple of the databases on the server and looks
> like it is false (I used SELECT DATABASEPROPERTYEX('<DBNAME>',
> 'IsAutoClose')).
> Thank you!
> Artie
>
> *** Sent via Developersdex http://www.codecomments.com ***
>|||Tibor
sp_MsHasDbAccess does not return any result at all .. it simply hangs.
So when I ran profiler while trying to execute it, it shows a bunch of
stuff under my login name and then sits on sp_MsHasDbAccess. (btw, some
of the statements before that was select IS_SRVROLEMEMBER ('sysadmin'),
which returns a 1; SELECT ISNULL(SUSER_SNAME(), SUSER_NAME()) correctly
returns my login name).
Thanks!
Aarti
*** Sent via Developersdex http://www.codecomments.com ***|||I was referring to tracing the TSQL code *inside* MsHasDbAccess. You need to
capture the right
events for this. See Alejandro's most recent post in this thread.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Art" <anonymousnospam@.devex.com> wrote in message news:%23gP7y1IjFHA.1412@.TK2MSFTNGP09.phx.
gbl...
> Tibor
> sp_MsHasDbAccess does not return any result at all .. it simply hangs.
> So when I ran profiler while trying to execute it, it shows a bunch of
> stuff under my login name and then sits on sp_MsHasDbAccess. (btw, some
> of the statements before that was select IS_SRVROLEMEMBER ('sysadmin'),
> which returns a 1; SELECT ISNULL(SUSER_SNAME(), SUSER_NAME()) correctly
> returns my login name).
> Thanks!
> Aarti
>
> *** Sent via Developersdex http://www.codecomments.com ***
>