Problem accessing data file

Question

I have just installed an program which uses SQL 2005 server. I have server and client on one machine. When I try to login to my client computer program it can not access data file. It gives following message:

Cannot connect to Medscribbler database.

Reason: General SQL error

[Microsoft][ODBC SQL server driver][SQL server]Cannot open database "medscribbler02" requested by login.The login failes.

Alias:officemed_mysql_new_local

How can I overcome this problem? Thanks in advance.

Answer 1

Hello,

I think that your error message is not the full one.So, please :

- could you provide the full and exact error message ? "The login failes." is not the usual message. I would think that the login you used is not allowed to connect to the database ( are you sure that the used login is allowed to connect to the database ? )

- could you explain what is the meaning of your alias ? If you are using a linked server, could you provide the properties of this linked server ?

- could you provide the connection string you are using to connect ?

- with my poor english, i am not sure to have understood "I have server and client on one machine".Please, could you tell us whether you are using remote connections ? ( the client computer is not the same as the computer on which the SQL Server is installed ? ). Are you sure that the SQL Server accepts remote connections ? What is the edition of your SQL Server 2005 ?

We are waiting for your feedback to try to help you more efficiently.

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

Answer 2

I am getting following error message as I posted in my previous post:

Cannot connect to Medscribbler database.

Reason: General SQL error

[Microsoft][ODBC SQL server driver][SQL server]Cannot open database "medscribbler02" requested by login.The login failes.

Alias:officemed_mysql_new_local

Server and client on one machine means I use both of them in one computer. I have installed server and client programs on one computer. I do not access database to remote machine. Rest of other questions by you is not understandable to me.

Answer 3

I have figured out the problem. It was problem with my downloader. I installed downloader from different site and now it works.

Answer 4

Hello jpatel_74,

I have marked your last post as answer .  And thanks for you to have shared your solution. Maybe, it will be useful for other visitors having the same problem.

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.