Can anybody give me some piece of information about creating a database on SQL Server Desktop Engine.
I have installed MSDE 2000 (Rel A) on my system running Win 2000 Prof. The SQL Server icon is now visible on my taskpar with green arrow showing 'Running - \\ALI-LAPTOP' But I want to use it to accomodate my database currently in Access. I have tried to use Upsizing Wizard to create new database on it but it is giving this error (Login failed for user 'sa' (with password 'sa'). Not associated with a trusted SQL Server connection.)
I was also not able to connect it with ODBC.
Can you please help me even if seems to be setup problem. Because, the MSDE setup completed successfully with a good system restart.
Regards,
Zulfiqar AliBased on your description you are not providing the correct password for the SA account, or you are not using Mixed Mode authentication. You need to know which Authentication method you enabled when you installed MSDE to know how to log in.
Let’s assume you didn’t specify anything, then you are using Windows Authentication and the SA account isn’t enabled. In that case, the Upsize Wizard in Access will only work if you choose the option to use Windows Authentication when choosing your database. If you want to create a database without using the Upsize Wizard, you can do that using oSQL to run a CREATE DATABASE statement.
More information about oSQL: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_osql_1wxl.asp
Help on CREATE DATABASE statement: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_create_1up1.asp?frame=true
If you are using Mixed Mode authentication you should be able to log in using an appropriate User/Password combination. Make sure you are using the right password for your SA account, you would have had to set the password when you installed MSDE.
Hope this helps,
Mike
No comments:
Post a Comment