Visual Studio 2005 Beta 2: Using SQL Server 2000 instead of SQL Express 2005

Hello

I installed Visual Studio 2005 Beta 2 without SQL Express 2005 because I already had SQL Server 2000 Developer Edition. Now I′m getting errors which says that SQL Express cannot create the needed databases when eg. launching a Web Starter Kit.

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

SQLExpress database file auto-creation error:

blabla...
Do I really need SQL Express? I′d like to use SQL Server 2000. Thanks for help.

[884 byte] By [Tuomas] at [2008-2-10]
# 1

The very first time you ever run SSE on your machine, it does some copying of files that take a while. So a timeout can occur.

If you would like to use SQL 2000, you certainly can. However, you won't get any of the Xcopy functionality that is associated with SSE. The design time makes certain assumptions about local data with SSE. But, if you are not using local data, you won't need it.

If you don't want SSE, stop the service and/or uninstall it.

LanceDelano at 2007-9-9 > top of Msdn Tech,SQL Server,.NET Framework inside SQL Server...
# 2

I received exactly the same message since a couple of days but I only made a installation of SQL Server 2005 June CTP and no other Visual Studio installation. It worked for some weeks but right now I have no idea. I cannot login to SQL Server Studio or Query Analyzer but SQL Server is running and I can log on with applications like Axapta. Any ideas what might go wrong here?

Regards, Carsten

CarstenM.Horlacher at 2007-9-9 > top of Msdn Tech,SQL Server,.NET Framework inside SQL Server...
# 3
Hi Lance,

What if I never installed the SQL Server Express? How can I uninstall it? or stop it?
I do get the exact same error - only for a page where I use authorization. I am using the Membership provided by .Net 2.0, with the SQL 2000 - there is no reference in my Web.config file to any other SQL instances other than my SQL 2000... I have been able to create the user and to log in - but on the page where authenticated access is required I get the above-mentioned error.

I am using the Beta 2 (v2.0.50215), with no SQL Server Express installed.

Please help!
Thanks,
Alicia

AliciaM at 2007-9-9 > top of Msdn Tech,SQL Server,.NET Framework inside SQL Server...
# 4
Oh, nevermind, Fritz (Onion) seemed to have been there, the magic is in the config file:

http://www.pluralsight.com/blogs/fritz/archive/2005/07/28/13547.aspx

Alicia

AliciaM at 2007-9-9 > top of Msdn Tech,SQL Server,.NET Framework inside SQL Server...
# 5
I have installed on one computer Sql Server 2005 Developer Edition (CTP Version) together with a Visual Studio 2005 Beta Edition (July Version) and after configuration some properties by example the Network access, I had a lot of errors from the SQL Server Management Studio received(The most of them are a Connection timeout error but others errors too).
In the same time I have made a test program to test the new SQL Server 2005 using DB Library or ATL OLE DB Consumer Templates.
The Both test programs are not running because I cannot open a connection on the SQL Server.
I've tried using the Windows Authentification and the SQL Server Authentification too. The both methods are not able to connect with the SQL Server.
The Programs are written in Visual C++ under the Visual Studio 2005.
I need help to my problems!
First why I cannot connect to the Sql Server. With DB Library example I was able to do it with a Beta Version from SQL Server 2005 but not any more with the CTP Version.
Why I cannot connect with the ATL OLE DB Consumer Templates ?
I want to hear some experiences from others developers with this CTP Version from SQL Server 2005.
It is really so buggy or it is not compatible with Window Server 2003 or it is because after installing the SQL Server 2005 I have made an update of the Visual Studio 2005 to be able to create Projects in Visual C++ and run some examples ?
The problem was that with the Visual Studio that it is coming with the SQL Server I was not able to create any Project under Visual C++ because I was receiving an error that the Template for the Visual C++ failed.
I need help !

For the detailed information about the Versions please read the next list:

Microsoft SQL Server Management Studio - Version 9.0.1187.
MDAC - Version 2000.086.1830.00(srv03_sp1_rtm.050324_1447)
Microsoft .Net Framework - Version 2.0.50712.6.
Microsoft Visual Studio 2005 - Version 8.0.50712.6(lab23df.050712-0600)

The Operating System it is an Windows Server 2003 Professional Version with SP1.

Vasile at 2007-9-9 > top of Msdn Tech,SQL Server,.NET Framework inside SQL Server...

SQL Server

Site Classified