Unable to create database from VS
I'm getting a time out when I attempt to create a new database from within Visual Studio 2005 Beta 2.
Here's what I did:
1) I installed VS2005 Beta 2 on a clean Windows 2003 Server w/SP 1 installation;
2) Went into VS, created a new project;
3) Clicked on the Database Explorer tab on the left side;
4) Right clicked on "Data Connects" and clicked on "Create New SQL Server Database...";
5) Clicked on the drop-down button for the server name combo box and selected the local computer (my only choice);
6) Left "Log on to the server" as "Use Windows Authentication" and specified a database name;
7) Clicked Ok;
8) Received the error message "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
I did notice by going into the SQL Configuration Management utility that SQL Browser had not started. I tried to manually start it, but it failed to start. But no error message was given.
Anyone have any ideas, suggestion?
TIA,
Richard
[1069 byte] By [
RichardR] at [2008-2-17]
I never was able to figure out how to get the version of SQL Server that VS 2005 Beta 2 installs to actually work with VS. But, I was able to come up with a work around.
Starting with a clean machine, I installed the SQL Server June 2005 CTP, and then installed VS 2005 Beta 2 (unchecking the install SQL Server option).
Hi
I've been struggling with this a bit with the same versions of VS and SQL but have managed to get it to work on XP.
The first thing is to check whether SQL Server itself (rather than the SQL Browser) is running which you can do via the configuration manager. Start it if it isn't. If it isn't running, you get the Timeout expired message when you try to access it.
So then go into VS and under the Server Explorer tab - Data Connections, click Add a connection and connect to the SQL server. When this connection is made, the server explorer tab shows more info as to which servers are running and the data connections that are open.
The option under Data Connections to Create New SQL Server database then works - at least here!
Hope this helps!
Mike
