|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
|
|
|
||||||
| ms.sqlserver.setup Questions about SQL Server. |
 |
|
|
LinkBack | Outils de la discussion |
07/11/2006, 20h59
|
#1 |
Messages: n/a
Hébergeur: |
MS SQL Express 2005 New Logins
Hi,
I have sucessfully created a trusted connection between MS SQL 2000 Standard and IIS, by creating a new SQL login user called IISSERVER$ and giving access to the database. Is there a way to create a new login in MS SQL Express 2005 ? thanks, |
|
|
08/11/2006, 06h42
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: MS SQL Express 2005 New Logins
Look in Books Online for
CREATE LOGIN And if you don't have the Management Studio Express, you can download it here: SQL Server 2005 SSMS Express Tutorial http://tinyurl.com/nqsca SQL Server 2005 Express Edition (Advanced/SSMS) http://msdn.microsoft.com/vstudio/ex...e/default.aspx http://msdn2.microsoft.com/en-us/library/ms365247.aspx http://www.microsoft.com/downloads/d...8-5A0F62BF7796 -- Arnie Rowland, Ph.D. Westwood Consulting, Inc Most good judgment comes from experience. Most experience comes from bad judgment. - Anonymous You can't someone get up a hill without getting a little closer to the top yourself. - H. Norman Schwarzkopf "Adriano" <adrian.owen@btconnect.com> wrote in message news:12l1tetpsooqv2c@corp.supernews.com... Hi, I have sucessfully created a trusted connection between MS SQL 2000 Standard and IIS, by creating a new SQL login user called IISSERVER$ and giving access to the database. Is there a way to create a new login in MS SQL Express 2005 ? thanks, |
|
|
|
10/11/2006, 11h21
|
#3 |
|
Messages: n/a
Hébergeur: |
Re: MS SQL Express 2005 New Logins
Thanks I downloaded it and its works a treat.
Adrian "Arnie Rowland" <arnie@1568.com> wrote in message news:O9wCGEwAHHA.1012@TK2MSFTNGP04.phx.gbl... Look in Books Online for CREATE LOGIN And if you don't have the Management Studio Express, you can download it here: SQL Server 2005 SSMS Express Tutorial http://tinyurl.com/nqsca SQL Server 2005 Express Edition (Advanced/SSMS) http://msdn.microsoft.com/vstudio/ex...e/default.aspx http://msdn2.microsoft.com/en-us/library/ms365247.aspx http://www.microsoft.com/downloads/d...8-5A0F62BF7796 -- Arnie Rowland, Ph.D. Westwood Consulting, Inc Most good judgment comes from experience. Most experience comes from bad judgment. - Anonymous You can't someone get up a hill without getting a little closer to the top yourself. - H. Norman Schwarzkopf "Adriano" <adrian.owen@btconnect.com> wrote in message news:12l1tetpsooqv2c@corp.supernews.com... Hi, I have sucessfully created a trusted connection between MS SQL 2000 Standard and IIS, by creating a new SQL login user called IISSERVER$ and giving access to the database. Is there a way to create a new login in MS SQL Express 2005 ? thanks, |
|
|
|
| Outils de la discussion | |
|
|
