开发者

SQL connection string for importing SO data sump

I'm trying to use Sam Saffron's program SoSlow (as suggest开发者_如何学JAVAed here) for importing SO's data sump into MS SQL Server 2008. Unfortunately, I have little idea of what I'm doing, and so do not know the Connection String that the program asks for.

I have tried the following syntax:

Data Source=SHIMI\SQLEXPRESS; Initial Catalog=SO; User Id=sa; Password=;

where SHIMI is the name of my machine, and SO is the name of the DB I've created. SoSlow announces that the login fails "Login failed for user 'sa'". Tried all other logins that are listed through the object browser in SQL Server Management Studio > Security > logins. I have not altered the server in any way since install, defaults apply.

What am I doing wrong? (besides asking noob questions)

Thanks!


You would have set an SA password during the installation of SQL Server Express - if you don't recall it you will need to reset it. Follow the steps here to reset.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜