all groups > sql server connect > may 2004 >
You're in the

sql server connect

group:

Connecting to Database


Connecting to Database Reg Coles
5/17/2004 8:46:41 AM
sql server connect:
Connected to SQL database via network but now I have
copied database onto laptop to work from home, I got SQL
2000 Server Edition on laptop but I cannot seem to connect
to local database on laptop, it comes up with errors
saying no database found or access denied. Tried to tell
it to look locally but nothing.Do I need to uninstall
server edition and put personal edition on? Do I did
the .log file on laptop as well?
Any help will be grateful.
RE: Connecting to Database S Kaliyan
5/17/2004 10:36:02 PM
pls check whether u have creted the user rights for the database, which u installed in ur laptop. if u have not created go to SQL enterprise Manager theire u can create new user. then u can able to accress the database

RE: Connecting to Database Reg Coles
5/19/2004 9:16:09 AM
After I wrote this posting I did alittle searching around the newsgroups and found similiar problem, and that suggested uninstalling SQL and reinstalling again. I did this and this time I could connect to local SQL server on local machine but it wouldn't see my database which I had backed up from the original. I didn't have the .ldf or .log file but I'm getting that in the next day so hopefully it will then allow me to create the database again. I've tried to create a new database and then restore my original into that database but it's not seen it.
AddThis Social Bookmark Button