dear sirits my first time to work with SQL server 2005
i've installed it and tried to connect to sqlcmd by :
run sqlcmd
i got errors
after that i logged to the database engine normally and created new database and tried again to relogin to the database engine but i failed and faced error:4064
i have three points needed to be answered :
1- SQLCMD loin problem
2- database engine error:4064
3- i need to import .mdb file to my new database
regards
1. See your post http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=671937&SiteID=1&mode=1
2. The user you are currently trying to login with does not have the appropiate permissions to the assigned default database or the database does not exist anymore. To solve this issue you can login with a priviledged account and change the default database of the user to a valid / granted one via the GUI or the proc sp_defaultdb.
3. Attach the database to your server and use the import wizrad to transfer the objects to the new database. You can also access the objects using the three part name notation like
SELECT * FROM DatabaseName.SchemaName.ObjectName
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment