Re: Problem with SQL Server 2005 Express Edition

Hi Roger

This is a prerequisit deployment, which means the SQL Server 2005 Express
Edition is downloaded and installed automatically during setup and before
tha application is installed. As far as I know, the SQL Server Management
Studio is not by default part of this installation (at least I can't find
it). And I don't want my users to download additional software to get this
working.

The strange thing is this: I can execute a select statement using the SQLCMD
tool without any problems. And from the Visual Studio 2005 I can go to the
Server Tools and connect to the database as well and query tables there,
also without errors. But my application come up with the "Login failed for
user "MyUser". The user is not associated with a thrusted server connection"
message all the time. I was wondering if my connection string should be
turned to Windows authentication instead, which it seems both SQLCMD and
Visual Studio is using (cause I don't have to login when doing that).

/PZ


"Roger Wolter[MSFT]" <rwolter@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:06C7E2FB-B373-4066-972B-EC2FB00D292E@xxxxxxxxxxxxxxxx
Here are the instructions for changing it.
http://msdn2.microsoft.com/en-us/library/ms188670.aspx


--
This posting is provided "AS IS" with no warranties, and confers no
rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"Preben Zacho" <post@xxxxxxxxxxxx> wrote in message
news:%23F%23hPh$lHHA.4568@xxxxxxxxxxxxxxxxxxxxxxx
Hi Roger

How can I determine this? And how do I change it if that is the case?

/PZ

"Roger Wolter[MSFT]" <rwolter@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:1105D112-C515-42E4-924D-85184144DC2A@xxxxxxxxxxxxxxxx
Since you are specifying the user name and password in the connection
string I assume you are using SQL Server authentication for your logins
rather than Windows authentication. One cause for that error is trying
to use a SQL Server login on a database server that is configured to
only accept Windows logins.

--
This posting is provided "AS IS" with no warranties, and confers no
rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"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: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: System Administrator Implied Permissions
    ... > sa login, it assigns it the System Administrator fixed ... > Now, given this, why does SQL Server ... in each database is always a member of the public and db_owner roles. ... Other sysadmin role members have the exact same ...
    (microsoft.public.sqlserver.security)
  • Re: No db access after publishing web site
    ... GRANT UPDATE TO ... If I detach and attach this database on a different PC (according that PC ... Cannot open database "pago" requested by the login. ... Are you detaching/attaching the SQL Server Express database correctly ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: installing help for sql 2005
    ... you have database users that are not mapped correctly to logins. ... SQL Server Documentation Team ... installation help with snap shots because i installed the sql server ... remote connections are disabled by default. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL SERVER 2008 Express + SP1
    ... I installed the SQLXPR_X64, and before I attempted the SP1, SQLEXPRESS database was 64bit for the configuration, better yet the repair do work anymore because SP1 changed them somehow to 32 and the original install was 64 ... If the error happened during upgrade of the 'master' database, it will prevent the entire SQL Server instance from starting. ... And regarding your sql server installation, ...
    (microsoft.public.sqlserver.setup)