Click here to Skip to main content
15,903,201 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Good day,

This might seem like it has been asked a million times but it still isn`t working.

We have configured the database as localhost and we have deployed it as a windows installation, the only problem that we have is that it cannot access the database at all, it gives the error “Cannot open database requested by login, login failed”

How do we get the database to create on the client side PC (not copy), because there will be no SQL server or even express installed.

Any help would be greatly appreciated

Thanks
Chris Van Tonder
Posted

Hi,

Will you be able to access database server from Server machine SQL Query analyser?

or

Install SQL client tool on client machine and check connection is happening or not?
 
Share this answer
 
Just a thought.

Have you tried pasting the error message into the search box of your favourite search engine? It will involve lots of reading as you will get loads of hits.

Most of them will boil down to a permissions problem.
 
Share this answer
 
Thanks for the Answer

yes, we have tryed it all :confused:

This was the best idea and we did try it and still no running program:
You need to grant login permissions to the ASPNET account as well as database permissions

but the database isn't working on the Computer yet. And we still have no idea, evan a tutorial that shows how to do it step by step would be awesome.

Thanks
 
Share this answer
 
Thanks for the answer

We can get the database to copy onto the client side, but not with any functionality, so when we install SQL we can attach the database and it will work yes.

But we are trying to get the database to work after the app. has been installed, no external SQL installed

We are using Visual Studio 2008 and sql server management studio 2008 R2

Here is a brief exp. of what we have tried so far :
Using a custom action to create database upon application installation, including a database file with the setup and deployment project.

Thanks
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900