Thursday, March 22, 2012

Cannot open the local NT group in the SQL Server Group

Hello,
I logged in as administrator, and tried to open the local
NT SQL Server and the message appears:
"A connection could not be established to (local).
Reason: SQL Server does not exist or access denied.
ConnectionOpen(Connect()).
Please verify SQL Server is running and check your SQL
Server Registration properties (by right-clicking on the
(local node) and try again."
I cannot access the registration properties.
I also checked event viewer and found the following error
message:
"There are multiple accounts with name
MSSQLSvc/mpserver01.martinousproduce.local:1433 of type
10. "
Any ideas on the problem? I restarted the SQL Server but
still unable to connect.
Thanks,
JoeDo you have more than 1 instance of SQL server installed?
Perhaps they are both trying to use the same IP port
number of 1433. Go to your NT services and see how many
instance you have of SQL. Try and start and connect to one
of them and then see if you have a clash of IP port
numbers.
If that isn't the case check that the SQL service is
running (by going to your NT services). Then, check
your "server network utility" from the program menu and if
TCP/IP is there take it out and put in named pipes. If
TCP/IP isn't there, then put it in. Remember you could
affect how people connect to the SQL server (i.e. is it in
production?) so take care when making your changes and
write them down so you don't forget how to undo them.
Hope this helps.
-J
p.s. just one more thought...do you have a name conflict
on the network? If so, it is possible that this SQL
server's IP stack did not initialize and therefore the SQL
services won't start.
>--Original Message--
>Hello,
>I logged in as administrator, and tried to open the local
>NT SQL Server and the message appears:
>"A connection could not be established to (local).
>Reason: SQL Server does not exist or access denied.
>ConnectionOpen(Connect()).
>Please verify SQL Server is running and check your SQL
>Server Registration properties (by right-clicking on the
>(local node) and try again."
>I cannot access the registration properties.
>I also checked event viewer and found the following error
>message:
>"There are multiple accounts with name
>MSSQLSvc/mpserver01.martinousproduce.local:1433 of type
>10. "
>Any ideas on the problem? I restarted the SQL Server but
>still unable to connect.
>Thanks,
>Joe
>.
>

No comments:

Post a Comment