RE: Initial Catalog SQL Connection String

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@xxxxxxxxxxxxxx

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

--------------------
From: =?Utf-8?B?TW9ycmlzIE5ldW1hbg==?= <Morris@xxxxxxxxxxxxx>
References: <F3F6330F-360A-4F24-9F26-95E7F346BEFD@xxxxxxxxxxxxx>
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
work.
--
Thanks
Morris


"Morris Neuman" wrote:

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.
--
Thanks
Morris


.

Relevant Pages

  • Re: Pass Through Query Question
    ... "Joe Williams" wrote in message ... > when you mentioned setting the connection string in the properties of the ... It runs with no problem using SQL query anlayzer. ...
    (microsoft.public.access.queries)
  • Re: Cant get SQL INSERT code to work
    ... I'm not sure you can use SQL to add data to an Excel file from another ... From Access Help file (covers JET SQL): ... ' Create the connection string. ... > 'Excel file and modify the SQL statement to fit your data. ...
    (microsoft.public.access.queries)
  • Re: Typed DataSet in DLL points to wrong database!
    ... Microsoft MSDN Online Support Lead ... Delighting our customers is our #1 priority. ... Where do I put the reference to connection string in the BL/DL Assembly? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Dataset - Error
    ... Server connection ... So looking at this we see that it is an error coming from SQL. ... Next we would look at the connection string, which is used to "login" to SQL ... What is does specify in regards to the userid is the ...
    (microsoft.public.cert.exam.mcsd)
  • Re: EXEC master..xp_cmdshell Prevention
    ... > I found that my web application did use a connection string in a file ... > stored procedures for every SQL statement would be impractical. ... I have created a new login account ...
    (microsoft.public.sqlserver.security)
Loading