Re: Problem with SQL Server 2005 Express Edition

Ok, so I got it to work now. I simply changed from SQL Authentication to
Windows Authentication and changed my connection string. Seems that the
deployment goes smoothly after all, since when installating the SQL Server
2005 as prerequisit, the installing user is created as a login user. I was
not awear of that.

The database itself is then created using a script call to SQLCMD and the
application can run without errors.

I can live with that, it makes the installation quite simple after all.

/PZ

"Preben Zacho" <post@xxxxxxxxxxxx> wrote in message
news:OKXT6f4lHHA.1776@xxxxxxxxxxxxxxxxxxxxxxx
Ok, I've read almost a million ng postings on this, still I can't solve
it. This place is my final hope.

I'll start from the beginning: I have a Windows application developed in
C#. It uses a SQL Server 2005 Express Edition database to store data. Now
I have created a deployment of this app and database, and I try to install
it on my own machine. No problems, works without errors.

Now, I put this deployment project on the network and a user downloads it
to his Vista machine and runs the setup. When he starts the app he gets
the following error message:

"Login failed for user "MyUser". The user is not associated with a
thrusted
server connection".

The connection string I use in my application is this:

Server=.\SQLEXPRESS;Database=MyDB;User ID=MyUser;Password=thissucks

Since I have no control over the Vista machine, I can't force him/her to
create a new account that is thrusted. All I want is to deploy my app and
database, without having to worry about authorization and stuff. If
possible, it should allow for ALL users to connect and use it.

I have already tried alot of the suggestions I've found, but lets start
all over so it will be right. What should I do to remove this error? How
can I deploy my database without having to think about
authorization/security stuff?

TIA

PZ





.

Relevant Pages

  • Re: Change Connection String at runtime.
    ... easily moved to another database, or have versions for each database. ... connection string to the connectionobject before the connection opens. ... *The Server IP number is different for every deployment. ... It appears that the generated code uses the application settings to ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Deploy SQL Express so my app still works on other machines
    ... This all assumes that SQL Express is installed on the user's ... I have an app which uses an SQL Express database. ... Is it the format of my connection string within my app. ...
    (microsoft.public.sqlserver.msde)
  • Re: Active Directory, IIS, and Application Roles...
    ... Can you specify in CONNECTION string of the application to which database to ... You will have to activate the Role immediatly after connection string. ... > I am creating an ASP.NET application that runs on a server with Windows ... > trusted connections and database roles for application access to SQL ...
    (microsoft.public.sqlserver.security)
  • Re: Counterpart to MS Enterprise Manager?
    ... That's where you can type SQL to do whatever you want. ... I'm looking all over and I cannot find this script window. ... database called SQLPOCKETGUIDE? ... For the SQL Developer do I use java connection string? ...
    (comp.databases.oracle.server)
  • Re: Second SQL adapter on the same database
    ... Microsoft Certified Technology Specialist: BizTalk Server 2006 ... changes the Initial Catalog part of the connection string to read Initial ... Since there is no database called NorthwindSecondary, ... stored procedure from a particular remote SQL Server 2000 database via ...
    (microsoft.public.biztalk.general)