Re: Help with database transfer

From: dagrom (dagrom_at_discussions.microsoft.com)
Date: 10/13/04 

Date: Wed, 13 Oct 2004 14:26:47 -0700

well if the ecommerce package you are running under your windows account and
your windows account is an admin on the sql server then i'd say the problem
lies within the connection string for the webpage that is trying to connect
to the sql server.

include "trusted_connection=true;" and get rid of the part in the connection
string that says "uid=sa;pwd=password;"

"David" wrote:

> Hi Bhanu and Dagrom, I am very bad at SQL. I have a ecommerce package
> that has all it's data in this SQL database. When I try and open my site it
> reads the test connection to the database has failed. When I asked the
> forum of the ecommerce package, they said to check SQL permissions....which
> brough t me here :)
>
> I will send more time this weekend on this and use the sugeesstions from
> you.
>
> Thanks Again for replying back
> David
>
>
> "David" <dross@si.rr.com> wrote in message
> news:%23TcYYLVsEHA.1276@TK2MSFTNGP12.phx.gbl...
> > HI, I am moving my SQL 2000 databse to a new server on a different
> > network. I have backup my datbase and then copied it over to the new
> > server. I do a restore and everyting seems to be there.
> > I am having permissions issues now. Are there some steps that I might
> > have missed as far as permissions is concerned that can cause problems?
> >
> > I believe the original database was using the SA account. I have switched
> > over to Windows Authentication.
> >
> > Thanks
> > David
> >
>
>
>

Relevant Pages

  • asp.net 2.0 login control
    ... A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.] ... These problems left me stranded for days, then today, on another machine, I hit a different set of problems I kept getting the following "Failed to generate user instance of SQL Server due to a failure in starting the process for the user instance. ... (Basically this is a new option in the connection string that allows you to point out where the ..mdf file resides eliminating the need to create database in some SQL instance.) ... Beware that the windows account of the user that first creates the connection in this databaseless manner, becomes exclusive user for this file and no other windows account will be able to create a connection to this file. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Associating a Windows account with a user
    ... Actually what I have is a database with three users but only one of them is associated with a Windows account. ... Juan Dent, M.Sc. "Narayana Vyas Kondreddi" wrote:> Is this the case of an orphanned user, due to moving the db from one domain> to another or something? ... > Can you simply grant access to that Windows login to SQL Server using ...
    (microsoft.public.sqlserver.security)
  • Re: DBA Permissions
    ... Keep in mind that without a Windows account, you can't log on to Windows itself to start the service, and since the SQL Server service is stopped, you can't connect to SQL Server. ... >>sql server account that is sysadmin. ...
    (microsoft.public.sqlserver.security)
  • Windows Authentication with IIS on separate machines
    ... -Web Application is using Basic Authentication set in IIS ... -Added user account TESTUSER and gave read access to ... in SQL server but doesn't work if user account was ... Windows account, ...
    (microsoft.public.sqlserver.security)
  • Re: Error: SQL Server does not exist or access denied
    ... > "Patrice" wrote in message ... >> Data Source is the server name, the database name goes in Initial ... >> AFAIK when using a Windows account, ... >>> I am updating a project from Access to run on our SQL Server DB. ...
    (microsoft.public.dotnet.framework.aspnet)