Welcome to the COE Discussion Forum! 

 

To participate in the discussion forum, you must be logged in to the website.  If you forget your login information, please contact COE Headquarters at coe@coe.org or (800) 263-2255.

If you are new to the COE Discussion Forum and would like to participate, please register.


Register Today
COE 2009 Annual PLM Conference & TechniFair

COE DISCUSSION FORUM
Subject: The Password of the role of SQLEXPRESS 2005

You are not authorized to post a reply.   
Author Messages
DAFTGLINT

24 Oct 2007 03:22 AM
Hello, One you install demo environment of release 17, the user Smarteam in sqlexpress which is created,Wich Password have?

Thank you.
EMAGNETTO

24 Oct 2007 07:33 AM
Check SMARTDBUSER

If uppsercase doesn't work, try lowercase.

Regards,
Eduardo

PIANNACCHIONE


24 Oct 2007 01:05 PM
Not sure what you are asking here? The service itself runs under NT AUTHORITY\NetworkService account so there is no need to touch that. The database itself would be managed by the sa account and you would have set that (not SmarTeam install). The only thing left is the SmarTeam admin user "joe" which has no password. Am I missing something?

Peter
HALE


24 Oct 2007 10:28 PM
Guys,

I saw Service Packs require attaching with the SMARTEAM user (Password was then SMARTEAM, I think it then became SMARTDBUSER). The main install was using the SA account. It was very confusing since it wasn't documented. The joe account for smDemo and the admin account for SmarTeam Express are only valid after you have attached to the SQL database using the sa or SMARTEAM SQL password. This is done with the Database Connection Manager and has resulted in many lonely hours when things did not want to connect.

Regards,
Hale

Badencorp - CATIA/SmarTeam - Installation, Training and Support!
An hour of hard work can often save you 60 seconds on Google.
DAFTGLINT

25 Oct 2007 03:03 AM
YES!
is SMARTDBUSER
Thank you a lot.
EMAGNETTO

25 Oct 2007 08:08 AM
Hale, seems you suffered like me with the passwd issues!!!
I still remember my suffering after (I think was) R17SP1 or SP2, when they changed the passwd for smarteam SQL user and hadn't documented it ...
On the other side, I agree with you about Data Connection Manager, and connection problems!!!
After struggling many, many times with it (at least with SQL), I solved after I could get SQL Server (mainly admin tools) to solve most of the attaching / detaching issues.

Eduardo
HALE


25 Oct 2007 02:52 PM
Eduardo,

Obviously I struck a merve. I hope you don't have nightmares tonight! Sorry about that.

Regards,
Hale

Badencorp - CATIA/SmarTeam - Installation, Training and Support!
An hour of hard work can often save you 60 seconds on Google.
You are not authorized to post a reply.
Forums > COE Forums > SmarTeam > The Password of the role of SQLEXPRESS 2005



ActiveForums 3.6

    

401 North Michigan Avenue, Chicago, IL 60611-4267 | (312) 321-5153 | (800) COE-CALL (U.S.)