Help moving from SQL Server Express to SQL Server Developer

I built a web application using my VS2005 installation, which includes SQL Server Express.

All works nicely. However, when I tried to move this application to a system with SQL Server Developer, I cannot get it to work at all - data access receives several errors, with the most common being this one:

Cannot open database "xyz.mdf" requested by the login. The login failed. Login failed for user 'MACHINE\ASPNET'.

Here is my connection string (with specific names changed, obviously):

Data source=MACHINE;Initial Catalog=xyz.mdf;Integrated Security=SSPI;User=Me;Password=MyPassword

I have given users MACHINE\ASPNET and MACHINE\Me all possible permissions (that I know) within SQL Server.

I have spent days on this, with no solution - help would be most appreciated.

use the following syntax for the connection string 

<connectionStrings> <add name="DatabaseConnection" connectionString="Data Source=(local);Initial Catalog=Northwind;IntegratedSecurity=SSPI;" /></connectionStrings>

|||

Thank you!

I must admit, I do not exactly understand the difference between my example and yours - but yours worked!

Much appreciated.

|||

Hi,

This is because unlike SQL Express, connecting to the SQL Server Developer edition requires you to use the instance name instead of the database file name.

Also, you need to remove the username and password to make sure that you're connecting with the windows integrated authentication.

help me with MSDE 2000A sp3

Hi,
i tried to install MSDE 2000A sp3, but the installation wasn't seccessful.
Can somebody help me and write me what I have to do to install MSDE 2000A sp3 with SQL authentification (and how can I add some user, database and table)?
I'm using Win XP sp2, .NET Framework 1.1 and VS .NET 2003 (but I haven't got SQL Enterprise manager)
Thank'sTry the solution in this post. Hope this helps.

http://forums.asp.net/941156/ShowPost.aspx
|||

Hi,
I tried to install MSDE via the solution in the previous post, but when I run OSQL, there is an error (SQL Server doesn't exist, or acces denied).
So, I haven't solved my problem yet.

|||The second option was to download the eval edition which will allow you to install the MSDE as a second instance and I forgot to tell you OSQL is not a very user friendly tool. If you cannot download most SQL Server books from Osborne press have the eval edition I am assuming you can get them from library check outs. Hope this helps.|||Ok,
can you send me some hyperlink to that files?
Thank's
|||

Here is the link and SQL Server developer edition is $40 less on the web. Hope this helps.
http://www.microsoft.com/sql/evaluation/trial/default.mspx

|||Thank's for help.