Cannot Register New Server in SQL Server 2008
-
Hello, I cannot register new server in SQL Server 2008. I can save it but cannot start all the items (Start, Stop, ...) under Service Control menu appear disabled.
-
Hello, I cannot register new server in SQL Server 2008. I can save it but cannot start all the items (Start, Stop, ...) under Service Control menu appear disabled.
-
Kujtim Hyseni wrote:
I cannot register new server in SQL Server 2008
What does that mean exactly? Are you saying that you INSTALLED sql server and start is not enabled in the windows services control panel applet?
No, my 'base' or don't know how to call it server works fine and I am connecting to it as usual via 'Microsoft SQL Server Management Studio'. But when I enter to 'Microsoft SQL Server Management Studio' and try to register new server i.e. from the menu I choose from menu 'Register...' then appears the form 'New Server Registration' I cannot save this new server but cannot start it.
-
No, my 'base' or don't know how to call it server works fine and I am connecting to it as usual via 'Microsoft SQL Server Management Studio'. But when I enter to 'Microsoft SQL Server Management Studio' and try to register new server i.e. from the menu I choose from menu 'Register...' then appears the form 'New Server Registration' I cannot save this new server but cannot start it.
-
When you went to the register dialog did you hit 'test'? If you did and it worked then can you log into the other box and start and stop the server from there? (Presumably you are using windows authentication.)
Yes I hit 'test' but I got the following message: ------------------- Testing the registered server failed. Verify the server name, login credntials, and database, and then click Test again. Additional information: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40- Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53) Yes I am using Windows authentication (in fact I can login via 'sa' also).
-
Hello, I cannot register new server in SQL Server 2008. I can save it but cannot start all the items (Start, Stop, ...) under Service Control menu appear disabled.
Right-click the icon for "Sql Management Studio", choose "Run as Administrator". That solved a similar problem I had under Sql Server 2005, should not be required for 2008 though. Since you can connect using the 'sa', I'd assume that the configuration is correct (TCP/IP being enabled) and that you have the name of the correct instance on the server. Do you have rights to start/stop the Sql Server Service when you open the "Services" list from the Configuration Panel?
Bastard Programmer from Hell :suss:
-
Yes I hit 'test' but I got the following message: ------------------- Testing the registered server failed. Verify the server name, login credntials, and database, and then click Test again. Additional information: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40- Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53) Yes I am using Windows authentication (in fact I can login via 'sa' also).
-
Kujtim Hyseni wrote:
Yes I hit 'test' but I got the following message:
So of course that is why you cannot now interact with it.
And ... ?
-
And ... ?