Re: What are the SharePoint WMSDE login credentials?

I am using Enterprise Manager to connect to the database on another machine
that has the WMSDE installed. When I try to register the sql server I get
"SQL Server registration failed because of the connection failure displayed
below. ...SQL Server does not exist or access denied.
COnnectionOpen(Connect())."...not a really helpfull message...but it never
gets to the Windows login screen to put in credentials. The only other
option is to try using SQL Server authentication but I don't know what those
credentials are.

So the question is when WMSDE is installed for SharePoint does it use the
Windows account or does it create a SQL Server account? If SQL account, what
is it?

Thanks,
Gery

--
Gery D. Dorazio
Development Engineer

EnQue Corporation
www.EnQue.com
www.ImagingHardware.com

"Cornelius J. van Dyk" <c@xxxxxxxxxxxxxxxxx> wrote in message
news:808B9A16-235B-4F63-BC96-306F7C19A0B1@xxxxxxxxxxxxxxxx
>I believe it will use the ID under which you configured WSS.
>
> Hope this helps.
>
> Thanks
> C
> http://spaces.msn.com/members/cjvandyk
>
>
>
> "Gery D. Dorazio" wrote:
>
>> Hi,
>>
>> When a WMSDE version of SharePoint is installed and the database is
>> created
>> automatically what are the login credentials that it creates? Are they
>> Windows login credentials, SQL credentials, or both? If they are Windows
>> credentials would they be the account from which the installation was
>> done?
>>
>> I need to look at data in this database directly through Enterprise
>> Manager(from another machine on the network) and can not connect to the
>> database without these credentials.
>>
>>
>> Thanks,
>> Gery
>>
>> --
>> Gery D. Dorazio
>> Development Engineer
>>
>> EnQue Corporation
>> www.EnQue.com
>> www.ImagingHardware.com
>>
>>
>>


.

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: 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)
  • Re: End User Requirements
    ... running MS-Access and not needing the full access installation, ... you are considering running a local copy of SQL server database. ...
    (microsoft.public.sqlserver.programming)
  • Re: Cluster will not fail over.
    ... As far as the TCP/IP issue goes, you had to rebuild the cluster and were not ... able to restore the master database. ... the entire installation configuration just as if nothing was running on it. ... > This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)