Re: Setting up a new database for application
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Mon, 17 Mar 2008 15:46:12 -0700
coady (coady@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
The error message was login failed after putting in user name and
password to set up database on a different SQL server.
"coady" <coady@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FF6843C4-FA09-464B-8958-6A8C4F37F6F8@xxxxxxxxxxxxxxxx
I am trying to set up a user account other than default sa to be able
to install a 3rd party application on a Windows 2003 box which during
the installation would create a database on a SQL 2005 server.
Both boxes are in AD. I tried giving both local and domain user
account, assigned sysadmin server role in SQL security, but it didn't
work.
What did you actually do? Could you describe that step by step? You
say "user account other than default sa" which suggests that you created
an SQL Server login. But then you mention the AD which applies to Windows
logins only.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Re: Setting up a new database for application
- From: Uri Dimant
- Re: Setting up a new database for application
- Prev by Date: Re: Restricting Access priviledge on SQL2000
- Next by Date: Re: ALTER TABLE TableName DISABLE TRIGGER error
- Previous by thread: Re: Setting up a new database for application
- Next by thread: Re: ALTER TABLE TableName DISABLE TRIGGER error
- Index(es):
Relevant Pages
|
