I have Sql 2005 Dev edition and VS 2005 Pro. I cannot access the server from server explorer. I know the SQL server is up and running. I cannot access it from Access either. I have tried the Data Connection Wizard (as outlined in the tread "Server Explorer - Sql Server) but no SQL server is there. I have no idea of how to proceed.
Suggestions please
Server Explorer and SQL 2005
David Anton
If the connection works in your management studio then the database system is running. Now in the solution explorer I have an icon on the top to add data connections to the system, is this there...
Under the server tree I do not see any databases, but when I add a data connection it creates a new tree for the database connections.
svxtc
Thanks
I can connect with the SQL Management Studio. Still, the SQL server instance does not appear in the server explorer. The server enumeration of the "connect to database" wizard is empty.
There must be a very simple answer.
AYK
Tried that, nothing.
I have activated a Microsoft Support Incident. When I get the answer, I will post it. Thanks to all for your suggestions.
Rachad
There is no icon any more this has been removed in the 2005 system.
Can you connect to the server using the sql management studio that is normally installed with the ev edition, If you do not have this installed I would install it as it will help with the management of the system.
Scott Coleman
Thanks Glen for the input.
I can open the "connect to database" dialogue. I choose SQL server as data source and .NET for SQL as data provider. On the next screen the server name is empty. If I click "refresh", I get a long delay with the hour glass before it times out without yielding a server name. I cannot get past this step.
I am using windows authentication and I am logged in on the local machine as an administrator. The surface area is completely open(tcp, memory, pipes, etc).
Any other suggestions
SP534
Try entering the database server your self...
Davids Learning
Is your sever agent running (from systray do you see an sql icon) If not you need to open the system manager and start the SQL Service...If you are unable to start from there you need to enable the dependent services from control panel administrative tools- services!
HTH
LSDev_KF
Thanks. The agent was off, but the server itself was active. I activated it.
Still no luck. There is no icon in the systray (as I have with another computer with a previous SQL Server. However, the server itself and the server agent are up and running (green triangle). I did a "standard" installation of both products. Do most SQL 2005 installations show a systray icon
An other suggestions