It was due to the password. In the script I created the password in
capitals. I didn't know that SQL Server Express was case sensitive. Now I
can connect with the server with either two of the users.
Thank you very much for the help, I was really stopped by this.
Re: Error 15401 using sp_grantlogin (not addressed by current KB articles) ... Restarting Windows 2000 resolved the problem for this particular account,... confused when it sees a duplicate SID.... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ... (microsoft.public.sqlserver.security)
Re: Scripting a SQL database ... Virtually everything SQL Server Enterprise Manager does can be ... To run the generated script in ASP, ... You can also create a DTS (Data Transformation Package)... that you'll want to select the "copy database objects and data" ... (microsoft.public.inetserver.asp.db)
Re: SQL Security ... except I'm having problems making it work in a script.... ;Set properties of DB objects and open connection to database... > from Books Online (within the SQL Server program group):... > communicate with SQL Server.... (microsoft.public.sqlserver.server)
Re: Scripting a SQL database ... Virtually everything SQL Server Enterprise Manager does can be ... To run the generated script in ASP, ... You can also create a DTS (Data Transformation Package)... that you'll want to select the "copy database objects and data" ... (microsoft.public.sqlserver.server)
Re: Upsizing from Access doubles varchar columns ... 32 Ridley Road... > in development and happy to drop and recreate everything then the ... > Tasks> Generate Script in Enterprise Manager), ... > design in Access will also be appropriate for SQL Server.... (microsoft.public.sqlserver.programming)
