April 13, 2008 at 1:49 am
What settings do i need to select (deselect) during the installation of Sql Server 2005 Standard Edition for use with VS 2008? I'll just be using it for my small project so i don't need an extensive (complete) installation. Moreover, i would be really grateful if anyone could tell me what settings i should use for each step of the installation process. I do have the Sql Server 2005 SP2. Below is my spec:
Windows Vista Ultimate x86
2 GB RAM
AMD X2 3600+
Thanks all in advance
April 14, 2008 at 6:27 am
For a development machine? Honestly, I'd just use the defaults. The one adjustment you might want to make is to limit the memory available to SQL Server to 1gb. Otherwise you'll see a lot of contention between Visual Studio & SQL Server. I can't think of anything else that would require a change.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 14, 2008 at 6:39 am
The thing is that i've already installed Sql Server 2005 with the default settings, and then SP2 after that. But even after this Sql Server is not shown in the Server Explorer of Visual Studio 2008. Here is what i have in the Server Explorer:
-Data Connections
-Servers
-Name of my Computer
+Crystal Report Services
+Event Logs
+Management Classes
+Management Events
+Message Queues
+Performance Counter
+Services
I've checked services.msc and Sql Server (MSSQLSERVER) is running, but i don't know why i'm not able to connect to it using Visual Studio 2008.
April 14, 2008 at 6:43 am
You just need to create a Data Connection to the databases that you want to access. You can't manage the server from Visual Studio. You need to Management Studio for that task. I'm looking at my VS2008 instance and seeing the same thing you are, but I've also got data connections.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 14, 2008 at 6:50 am
When i try to do an "Add Connection" or "Create New Sql Server Database" there is nothing in the Server Name list. I'm assuming that if indeed Sql Server is running, then it should be listed, or do i need to enter the server name manually?
April 14, 2008 at 6:53 am
You may have to enter it manually, but you could try hitting the Refresh button and seeing if it's in the drop down. Unfortuantely, that's usually a painful choice because it will look to your entire enterprise to see where SQL Server servers are available for connection. I usually just type it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 14, 2008 at 7:07 am
Unfortunately even if i refresh the list i don't get anything. Well i think i'm going to install it again and then see if it works properly. Thanks for sticking with me. I'll be back with my problems.
April 14, 2008 at 7:33 am
Before you go throough the reinstall, be sure that you can connect to it using SQL Server Management Studio. You want to know it's up and running before you start trying to get other applications connected.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 14, 2008 at 8:05 am
I've done it guys, thanks for all your help @Grant Fritchey. The problem was that i didn't add myself to the admin's privileges.
May 10, 2009 at 1:28 pm
Hi guys
I couldn't see the list of servers too but when I started the "SQl Server Browser" service and restarted then the list of servers are shown.
Do as following:
- "administrative tools > Services"
- Right click "SQl Server Browser" and click the properties.
- Select "Automatic" in start up drop down list.
- Restart your computer.
Good luck
May 10, 2009 at 2:42 pm
Hi
If your system is a development system you should change two things:
Change the "Recovery Model" of your database(s) from "Full" to "Simple". Best would be to change also for "model" database. Usually you don't want the full recovery mode on your development database. This setting may differ on test system.
Change the "Autogrowth" property of your database(s) from "1 MB" to anything more suggestive ;-). Same for model db.
Greets
Flo
March 6, 2010 at 1:32 am
thx man
Viewing 12 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply