| Author |
Topic |
|
ezfiler
Starting Member
3 Posts |
 Posted - 2006-03-18 : 12:01:30
|
| I have sql server 2000 Personal Edition with service pack 4 loaded on a laptop running Windows XP and I'm trying to install a program that automatically loads all the tables and files to the SQL Server.I keep getting the following error:Your connection could not be created. Check your settings. The error was: Login failed for user "FileArch"The program had been previously loaded on this laptop and I had to rebuild the hard drive. When I check Enterprise manager I see in Databases that the FileArch database is in Master as opposed to its own database.The database missing is called FileArch.If anyone can provide me with help to solve this I'd be grateful as a new member.Bob |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-03-18 : 23:16:40
|
things to check:1. is filearch login existing? if yes, check permission if it has the rights to create objects and has access to the database, if no create the login and provide appropriate permissions2. is the database existing? if no, create then go to #1, if yes, check #1this i can't understand but i guess you meant login instead of databasequote:
I see in Databases that the FileArch database is in Master
--------------------keeping it simple... |
 |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-03-19 : 02:57:20
|
| If FileArch Exists then make it Db_Owner for the database which you are trying to load the tables. and if doesnt Exists then make the user FileArch and make it Db_owner. so it can get all the permission on the database. Sucess Comes to those who Believe in Beauty of their Dream.. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-03-19 : 08:19:59
|
ok,this is weird...been getting these things lately  --------------------keeping it simple... |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-03-19 : 08:33:23
|
quote:
Originally posted by jen
ok,this is weird...been getting this things lately
Sorry didnt understood.. Sucess Comes to those who Believe in Beauty of their Dream.. |
|
|
|
ezfiler
Starting Member
3 Posts |
Posted - 2006-03-19 : 09:31:35
|
quote:
Originally posted by jen
things to check:1. is filearch login existing? if yes, check permission if it has the rights to create objects and has access to the database, if no create the login and provide appropriate permissions2. is the database existing? if no, create then go to #1, if yes, check #1this i can't understand but i guess you meant login instead of databasequote:
I see in Databases that the FileArch database is in Master
--------------------keeping it simple...
|
|
|
|
ezfiler
Starting Member
3 Posts |
Posted - 2006-03-19 : 09:42:10
|
| FilerArch exists in the Master, how do I make DB_Owner as suggested.I am very grateful for the help, I have a major presentation on Wednesday and need to get installed to build my demo.I need be I could e-mail the program and see if you could get it to install.Bob |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-03-19 : 19:54:18
|
| guess you didn't follow through...1. is the database existing? if yes, then tick the db_owner on the properties box when you double click the login in the enterprise manager security folder-->database access tab-->tick the database and provide db_owner rights2. if the database is not existing, create the database first and goto step 1--------------------keeping it simple... |
|
|
|
|
Connection could not be made, login failed for use