Skip to main content
W
Weber1-Visitor
1-Visitor
April 25, 2010
Question

SQL Database access and location

  • April 25, 2010
  • 1 reply
  • 3070 views
When installing WPPT a new SQL database named ##MSEE## or similar is created. This database is located in the C-drive of the server where WPPT is installed. I dont want this cause of disk space. Futher I might have an existing SQL installation that I want to use. Now to my question: How can I determine the loaction, name and access of the SQl database used by WPPT ? I could not find a option for this when installing WPPT, when I moved the SQL after installing I couldn't connect the ProE clients. Also I had no acess to the SQL databases using SQL managment studio.

1 reply

P
ptc-22111921-Visitor
1-Visitor
April 27, 2010
you can not just move the databse files. you must detach the database. Move the files. Then reattach the database. Here are the Instructions http://support.microsoft.com/kb/224071
W
Weber1-VisitorAuthor
1-Visitor
April 30, 2010
Hallo Keith thnak you but this link does not work.. Now how can I USE a database when installing WPPT ? Is this right that WPPT install SQL Express if no other SQL Server is installed ?
P
ptc-22111921-Visitor
1-Visitor
May 1, 2010
I Am not sure why the link does not work. I tested it and it is fine. If you do not have sql installed it will use sql express for the content datbase and windows database for the share point side.
Terms & ConditionsAccessibility statement