|
|
You're in the
sql server connect
group:Problems connecting to SQL-Server
sql server connect:
we have an customer trying to run our app. after installation. They get the error messeage: Login failed for user skdomain/skuser. Our app uses ADO.NET and the database is MS SQL Server. The program and sql server is installed on a separate server. To run the app. they have 8 application servers with metaframe. Our app is set up to connect to the database using WIN NT autentication.
Is skdomain\skuser been granted access with a login in SQL Server? Do
they have the required users added to the server as well as setup as users in the database? -Sue On Mon, 25 Oct 2004 08:23:03 -0700, "Olav" [quoted text, click to view] <Olav@discussions.microsoft.com> wrote:
>Hi, >we have an customer trying to run our app. after installation. They get the >error messeage: Login failed for user skdomain/skuser. >Our app uses ADO.NET and the database is MS SQL Server. The program and sql >server is installed on a separate server. To run the app. they have 8 >application servers with metaframe. Our app is set up to connect to the >database using WIN NT autentication. >Our app. runs fine if the user log in as domain administrator.
Hi Sue,
i dont follow you here. My be because i use a standalone XP Pro PC? Where do i "click" to grant access with a login in SQL Servers? Can i see it on my PC or must i use my customers? Olav [quoted text, click to view] "Sue Hoegemeier" wrote:
> Is skdomain\skuser been granted access with a login in SQL Server? Do > they have the required users added to the server as well as setup as > users in the database? > > -Sue > > On Mon, 25 Oct 2004 08:23:03 -0700, "Olav" > <Olav@discussions.microsoft.com> wrote: > > >Hi, > >we have an customer trying to run our app. after installation. They get the > >error messeage: Login failed for user skdomain/skuser. > >Our app uses ADO.NET and the database is MS SQL Server. The program and sql > >server is installed on a separate server. To run the app. they have 8 > >application servers with metaframe. Our app is set up to connect to the > >database using WIN NT autentication. > >Our app. runs fine if the user log in as domain administrator. >
Thanks Sue,
this can take som time when there is 200 users to add? May be a faster approach is to use SQL authentication. Then it would work with only one user registered the same place? Is there a difference in connection speed with NT and SQL authentication? Olav [quoted text, click to view] "Sue Hoegemeier" wrote:
> You won't see skdomain\skuser on your PC. A windows login is > specific to the domain or workgroup. When using windows > authentication, any login you want to have access to SQL > Server needs to be added as a login for SQL Server. In > Enterprise Manager go to Security and then to Logins. Right > click on select New Login. Click the button to the right of > the Name text box and you will pull up the domain or > workgroup logins that you can add as logins for SQL Server. > > -Sue > > On Wed, 27 Oct 2004 03:37:04 -0700, "Olav" > <Olav@discussions.microsoft.com> wrote: > > >Hi Sue, > >i dont follow you here. My be because i use a standalone XP Pro PC? > >Where do i "click" to grant access with a login in SQL Servers? Can i see it > >on my PC or must i use my customers? > > > >Olav > > > >"Sue Hoegemeier" wrote: > > > >> Is skdomain\skuser been granted access with a login in SQL Server? Do > >> they have the required users added to the server as well as setup as > >> users in the database? > >> > >> -Sue > >> > >> On Mon, 25 Oct 2004 08:23:03 -0700, "Olav" > >> <Olav@discussions.microsoft.com> wrote: > >> > >> >Hi, > >> >we have an customer trying to run our app. after installation. They get the > >> >error messeage: Login failed for user skdomain/skuser. > >> >Our app uses ADO.NET and the database is MS SQL Server. The program and sql > >> >server is installed on a separate server. To run the app. they have 8 > >> >application servers with metaframe. Our app is set up to connect to the > >> >database using WIN NT autentication. > >> >Our app. runs fine if the user log in as domain administrator. > >> > >> >
You won't see skdomain\skuser on your PC. A windows login is
specific to the domain or workgroup. When using windows authentication, any login you want to have access to SQL Server needs to be added as a login for SQL Server. In Enterprise Manager go to Security and then to Logins. Right click on select New Login. Click the button to the right of the Name text box and you will pull up the domain or workgroup logins that you can add as logins for SQL Server. -Sue On Wed, 27 Oct 2004 03:37:04 -0700, "Olav" [quoted text, click to view] <Olav@discussions.microsoft.com> wrote:
>Hi Sue, >i dont follow you here. My be because i use a standalone XP Pro PC? >Where do i "click" to grant access with a login in SQL Servers? Can i see it >on my PC or must i use my customers? > >Olav > >"Sue Hoegemeier" wrote: > >> Is skdomain\skuser been granted access with a login in SQL Server? Do >> they have the required users added to the server as well as setup as >> users in the database? >> >> -Sue >> >> On Mon, 25 Oct 2004 08:23:03 -0700, "Olav" >> <Olav@discussions.microsoft.com> wrote: >> >> >Hi, >> >we have an customer trying to run our app. after installation. They get the >> >error messeage: Login failed for user skdomain/skuser. >> >Our app uses ADO.NET and the database is MS SQL Server. The program and sql >> >server is installed on a separate server. To run the app. they have 8 >> >application servers with metaframe. Our app is set up to connect to the >> >database using WIN NT autentication. >> >Our app. runs fine if the user log in as domain administrator. >> >>
When you have a lot of users, it's generally more efficient to use
Windows groups rather than individual Windows logins. Another consideration is that you don't necessarily have to use just Enterprise Manager to add the logins - you can execute sp_grantlogin to grant a windows account login access to SQL Server. You can use sp_grantdbaccess to allow the login access to a database. This can give you more flexibility in terms of building a script the users access. There is no real performance difference between the two authentication modes. Windows Authentication is more secure than using SQL logins. You may also want to check SQL Server books online and read up on application roles as that may be something you would want to look into. -Sue On Wed, 27 Oct 2004 06:47:06 -0700, "Olav" [quoted text, click to view] <Olav@discussions.microsoft.com> wrote:
>Thanks Sue, >this can take som time when there is 200 users to add? >May be a faster approach is to use SQL authentication. >Then it would work with only one user registered the same place? >Is there a difference in connection speed with NT and SQL authentication? > >Olav > > >"Sue Hoegemeier" wrote: > >> You won't see skdomain\skuser on your PC. A windows login is >> specific to the domain or workgroup. When using windows >> authentication, any login you want to have access to SQL >> Server needs to be added as a login for SQL Server. In >> Enterprise Manager go to Security and then to Logins. Right >> click on select New Login. Click the button to the right of >> the Name text box and you will pull up the domain or >> workgroup logins that you can add as logins for SQL Server. >> >> -Sue >> >> On Wed, 27 Oct 2004 03:37:04 -0700, "Olav" >> <Olav@discussions.microsoft.com> wrote: >> >> >Hi Sue, >> >i dont follow you here. My be because i use a standalone XP Pro PC? >> >Where do i "click" to grant access with a login in SQL Servers? Can i see it >> >on my PC or must i use my customers? >> > >> >Olav >> > >> >"Sue Hoegemeier" wrote: >> > >> >> Is skdomain\skuser been granted access with a login in SQL Server? Do >> >> they have the required users added to the server as well as setup as >> >> users in the database? >> >> >> >> -Sue >> >> >> >> On Mon, 25 Oct 2004 08:23:03 -0700, "Olav" >> >> <Olav@discussions.microsoft.com> wrote: >> >> >> >> >Hi, >> >> >we have an customer trying to run our app. after installation. They get the >> >> >error messeage: Login failed for user skdomain/skuser. >> >> >Our app uses ADO.NET and the database is MS SQL Server. The program and sql >> >> >server is installed on a separate server. To run the app. they have 8 >> >> >application servers with metaframe. Our app is set up to connect to the >> >> >database using WIN NT autentication. >> >> >Our app. runs fine if the user log in as domain administrator. >> >> >> >> >> >>
Using a single SQL Server auth login for 200 users is not very secure.
Although I'm sure the DBA will probably appreciate getting out and talking to all 200 employees every time he decides to change that password. Tracking down any security issues should be easier, since you don't actually have to track 200 users; just track the one login and blame all 200 users! [quoted text, click to view] "Olav" <Olav@discussions.microsoft.com> wrote in message news:A35FA747-EAF6-44CE-AAAB-659A6C80AB14@microsoft.com... > Thanks Sue, > this can take som time when there is 200 users to add? > May be a faster approach is to use SQL authentication. > Then it would work with only one user registered the same place? > Is there a difference in connection speed with NT and SQL authentication? > > Olav > > > "Sue Hoegemeier" wrote: > > > You won't see skdomain\skuser on your PC. A windows login is > > specific to the domain or workgroup. When using windows > > authentication, any login you want to have access to SQL > > Server needs to be added as a login for SQL Server. In > > Enterprise Manager go to Security and then to Logins. Right > > click on select New Login. Click the button to the right of > > the Name text box and you will pull up the domain or > > workgroup logins that you can add as logins for SQL Server. > > > > -Sue > > > > On Wed, 27 Oct 2004 03:37:04 -0700, "Olav" > > <Olav@discussions.microsoft.com> wrote: > > > > >Hi Sue, > > >i dont follow you here. My be because i use a standalone XP Pro PC? > > >Where do i "click" to grant access with a login in SQL Servers? Can i see it > > >on my PC or must i use my customers? > > > > > >Olav > > > > > >"Sue Hoegemeier" wrote: > > > > > >> Is skdomain\skuser been granted access with a login in SQL Server? Do > > >> they have the required users added to the server as well as setup as > > >> users in the database? > > >> > > >> -Sue > > >> > > >> On Mon, 25 Oct 2004 08:23:03 -0700, "Olav" > > >> <Olav@discussions.microsoft.com> wrote: > > >> > > >> >Hi, > > >> >we have an customer trying to run our app. after installation. They get the > > >> >error messeage: Login failed for user skdomain/skuser. > > >> >Our app uses ADO.NET and the database is MS SQL Server. The program and sql > > >> >server is installed on a separate server. To run the app. they have 8 > > >> >application servers with metaframe. Our app is set up to connect to the > > >> >database using WIN NT autentication. > > >> >Our app. runs fine if the user log in as domain administrator. > > >> > > >> > > > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |