Installation and Setup

Re: Visual Studio automatically installed SQL Server 2005

helpjet — Sun, 05 Jul 2009 08:59:48 GMT

After googleing two days, finally I decided to uninstall SQL Server and VS 2008.

I reinstalled both but this time I installed SQL Server 2008 Express with "Default" instance. Before I installed the SQL with "named" instance.

After re-installing both SQL and VS, I created web portal test application, compiled it and when I executed it, everything went smooooooothly. No errors this time.

But I still I want to find out why named instance wasn't working with VS ?

Re: Visual Studio automatically installed SQL Server 2005

helpjet — Sat, 04 Jul 2009 06:53:08 GMT

I installed the SQL server 2008 with "MSSQLSERVER" as instance name. Since web parts uses a "personlization provider" to store the portal configuration, it is trying to create AspNetDb.mdf database file at run time. There is no connection in web.config.

So I don't know how to tell VS that I am not using default instance "SQLEXPRESS". I am using "MSSQLEXPRESS"

Please help.............

Re: Visual Studio automatically installed SQL Server 2005

mudassarkhan — Sat, 04 Jul 2009 06:23:08 GMT

refer here

http://www.aspsnippets.com/post/2009/05/09/Exception-error-26-Error-Locating-Server-Instance-Specified.aspx

Re: Visual Studio automatically installed SQL Server 2005

helpjet — Sat, 04 Jul 2009 05:29:49 GMT

I am playing with web portals in ASP.Net

I have created a simple project just to know how portals work. But when I try to execute my application, I get following error. I am really sick of this error since I have never been exposed to SQL before.

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

How can I solve this , what is wrong , what is the solution ?

Re: Visual Studio automatically installed SQL Server 2005

helpjet — Sat, 04 Jul 2009 05:23:05 GMT

Thanks for the reply but I have already removed it (SQL 2005)

Re: Visual Studio automatically installed SQL Server 2005

mudassarkhan — Sat, 04 Jul 2009 04:00:41 GMT

helpjet:
After installing VS, I see SQL 2005 was also installed on my system. Now I have SQL Server 2005 and 2008. I don't wnt 2005, should I remove it or not.

That are just client tools for SQL Server and will not interfere or crash anywhere I am using VS 2005 and VS 2008 together on the same machine and same is the case with me.

Just carry on you will not get any errors

Visual Studio automatically installed SQL Server 2005

helpjet — Fri, 03 Jul 2009 18:31:04 GMT

I formatted my system and then installed the following in the order

1) XP

2) IIS

3) IE 8

4) XP SP3

5) .NET 3.5 SP1

6) Windows Installer 4.5

7) Power Shell 1.0

8) SQL Server 2008 Express with Tools

9) Visual Studio (VS) professionl (90 day free trial)

After installing VS, I see SQL 2005 was also installed on my system. Now I have SQL Server 2005 and 2008. I don't wnt 2005, should I remove it or not.

If I should, can you tell me how to ? (just simply remove from Add Remove Programs ? )

I don't want VS throwing errors becuse of 2005 nd 2008