When I opened a connection, the old connection was gone, perhaps a reboot?
I am able to connect to the instance from the server and create a table and query a DB. I am however unable to connect to the Instance from my 2005 client.
How can I tell the install was successful? Looking in the event logs and not seeing anything around the time it would have completed.
I checked and Remote connections is enabled. TCP and Pipes are enabled. SQL Browser is stopped,when attempt to access to start that I get an error:
The service cannot be started, either because it is disabled or because it has no enabled devices asssociated with it [0X80070422]
I can't telnet into 1433 on the server.. might be firewall. Do I really need to open that manually?
My client is SQL 2005, I believe I've connect to sql 2008 DBs. Should I upgrade the client on my client?
I attempted to stop and start the instance. when I started it I got this mess:
Server stack trace:
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.GetObjectExplorer(Boolean activateWindow)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ShowError(Exception e)
View Complete Post