Initial Catalog SQL Connection String

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Morris Neuman - 20 Mar 2008 19:34 GMT

Hi,
Using VS 2005, I made a project and successfully connected to an SQL2005 db
using connection string with Initial Catlog=CallMaster (CallMaster is our db).

In trying to run the same app in VS2008, I kept getting error "Exception
Details: System.Data.SqlClient.SqlException: Cannot open database
"CALLMasterSQL" requested by the login. The login failed.
Login failed for user '4600CJER\Administrator'.".

When I changed the connection string and set Initial Catalog=CallMaster.mdf
(adding the .mdf), everything worked again.

Is this a problem with VS2008 or SQL?

Please advise.

Signature

Thanks
Morris

Reply to this Message

Morris Neuman - 20 Mar 2008 19:47 GMT

I realized my mistake. I attached the file on the sql server as
CallMaster.mdf which is why the connection string without the mdf did not
work.

Signature

Thanks
Morris

> Hi,
> Using VS 2005, I made a project and successfully connected to an SQL2005 db
[quoted text clipped - 11 lines]
>
> Please advise.

Reply to this Message

Steven Cheng - 21 Mar 2008 02:38 GMT

Hi Morris,

I'm glad that you've figured the problem out. BTW, for ASP.NET programming
issue, I would recommend you post in the following newsgroup:

microsoft.public.dotnet.framework.aspnet

since more ASP.NET guys may have chance to look into the issues.

Best regards,

Steven Cheng
Microsoft MSDN Online Support Lead

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
msdnmg@microsoft.com.

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------

>From: =?Utf-8?B?TW9ycmlzIE5ldW1hbg==?= <Morris@online.nospam>
>References: <F3F6330F-360A-4F24-9F26-95E7F346BEFD@microsoft.com>
>Subject: RE: Initial Catalog SQL Connection String
>Date: Thu, 20 Mar 2008 11:47:19 -0700

>I realized my mistake. I attached the file on the sql server as
>CallMaster.mdf which is why the connection string without the mdf did not
[quoted text clipped - 15 lines]
>>
>> Please advise.

Reply to this Message

Webmaster Forum / ASP / Database Access / March 2008

Initial Catalog SQL Connection String