Re: Login fails. Why?
From: Dan Guzman (danguzman@nospam-earthlink.net)
Date: 09/21/02
- Next message: BP Margolin: "Re: HELP - no sa password "about to reinstall sql7""
- Previous message: Max Billingsley: "HELP - no sa password "about to reinstall sql7""
- In reply to: C.G.: "Login fails. Why?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Dan Guzman" <danguzman@nospam-earthlink.net> Date: Sat, 21 Sep 2002 10:27:43 -0500
Apparently, the 'UserName' login has not been granted access to the
database. You can do this with Enterprise Manager or with the following
script in Query Analyzer:
USE MyDatabase
EXEC sp_adduser 'UserName'
The user will need permissions on referenced database objects, either
directly or via role membership.
-- Hope this helps. Dan Guzman SQL Server MVP ----------------------- SQL FAQ links (courtesy Neil Pike): http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800 http://www.sqlserverfaq.com http://www.mssqlserver.com/faq ----------------------- "C.G." <chris@cyberjock4hire.com> wrote in message news:393001c260ad$c65f2c90$37ef2ecf@TKMSFTNGXA13... > I'm running a dev version of my company's website on my > laptop (Win2kAdv server, MS SQL Server 2K) It's an exact > replica of the original DB but I'm getting this... > > Error Type: > Microsoft OLE DB Provider for ODBC Drivers (0x80004005) > [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open > database requested in login 'CompanyDB'. Login fails. > /Common/conndatabase.asp, line 29 > > Line 29: conn.Open > connString "DSN=CompanyDB;UID=UserName;PWD=PassWord" > > What am I doing wrong? Where are all the places I need to > check for this user's permissions? > > TIA! >
- Next message: BP Margolin: "Re: HELP - no sa password "about to reinstall sql7""
- Previous message: Max Billingsley: "HELP - no sa password "about to reinstall sql7""
- In reply to: C.G.: "Login fails. Why?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
