Re: WSS 2 to WSS 3 migration error

Thanks for your response Peter. I know this is a dumb question, but how
would I grant access to the user? I've done the migration a few times to a
win2003 box running v3, but not to a 2008 box. I don't think that is the
issue...I'm guessing a patch was released that changed the behaviour. I'm
logged in under an account that has admin on the server itself, I thought
that granted me access to the DB. Yes, it's obvious I don't know much about
SQL server or in this case Windows internal DB. I was surprised because this
was not an issue for me in the past.

Thanks for any information.

"Peter Kessler" wrote:

Ariel wrote:

Hello,

I'm migrating from WSS 2 on Win2003 to WSS 3 on Win2008. When I run
the following:

sqlcmd -S \\.\pipe\mssql$microsoft##ssee\sql\query -E

I get this error:

Msg 18456, Level 14, State 1, Server GRANGER\MICROSOFT##SSEE, Line 1
Login failed for user 'XX\xxxxxxxxx'.

How can I fix this?

Maybe you can try another Windowsuser. It is possible that your account
is not allowed to work with the database.

--


.

Relevant Pages

  • Re: WSS 2 to WSS 3 migration error
    ... I can connect with the local admin account, ... would I grant access to the user? ... SQL server or in this case Windows internal DB. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Controlling access with custom groups
    ... Adding a fixed database role to a user-defined role is not permitted. ... Columnist, SQL Server Professional ... db_datareader, through Enterprise Manager. ... then grant access to the role. ...
    (microsoft.public.sqlserver.security)
  • Re: prevent developers writting to our SQL DB ?
    ... Then only grant access to the procs and views and deny access directly to ... Abstract this through the use of a database role. ... Looking for a SQL Server replication book? ... How can we employ this in a VB and SQL environment when users need ...
    (microsoft.public.sqlserver.server)
  • Re: cant connect
    ... For the GRANT access i 've use osql syntax but it return a message as Wrong ... i can't login using the 'sa' account from other machine. ... >> can connect to msde without problem on this computer. ...
    (microsoft.public.sqlserver.msde)
  • Re: Windows authentication failed on SQL2000 +NT4
    ... Thanks for your reply Dejan, ... followed the instructions from the SQL Server Book. ... > You have to grant access to SQL Server to Win users and groups. ...
    (microsoft.public.sqlserver.security)
Loading