May 11, 2009 at 2:30 am
My stand alone PC is called blackdell
When I try to run Management Studio - Server name BLACKDELL (or blackdell) I get:
"Cannot connect to BLACKDELL
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: Names Pipes Provider, error:40- Could not open a connection
to SQL Server) (Microsoft SQL Server Error:2)"
I do not know how to configure for remote connections, but surely I am only trying to connect locally anyway.
It used to work. I just did a complete reinstall but still does not work.
I know Reporting Services is running,but not sure if SQL Server itself is running !
Thanks
May 11, 2009 at 3:52 am
If you have a named instance of SQL server, then the name you have to use is different from the name of the PC. Try BLACKDELL\SQLEXPRESS or BLACKDELL\SQL2005.
Otherwise, you can try to use the "browse fro servers" option when connection with management studio.
ciao
Giacomo
May 11, 2009 at 6:55 am
Thanks Giacomo
Tried these but still not working. Have also tried entering the server name as dot (.) .
The server is registered under Local Server Groups
There must be something very simple I have not got right !
Under Task Manager I can only see Reporting Services running. Do I need to do something to start SQL Server 2008 itself perhaps ?
May 11, 2009 at 4:59 pm
Hi Richard
Go to "SQL Server Configuration Manager".
* Select "SQL Server Network Configuration" -> "Protocols for MSSQLSERVER" and enable "Named Pipes" and "TCP/IP" (to be able to connect from another computer).
* Select "SQL Server Services" node. In detail view right click "SQL Server (MSSQLSERVER)" and select properties. On "Log On" tab select click "Start" (click "Restart" if it's already running). On "Service" tab change "Start Mode" to automatically.
Greets
Flo
May 14, 2009 at 10:50 am
Flo - thanks for your help - will give this a try later. (Had to uninstall due to other problems with my PC !)
R.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply