39 réponses à ce sujet

[Silas TNA5CoDe]

FIRTS:
Have you encountered the error 'CREATE DATABASE Permission denied in database 'master'' even though you are logged into Windows Vista with administrator privileges.

Reason for the error : Windows Vista users that are members of the Windows Administrators group are not automatically granted permission to connect to SQL Server, and they are not automatically granted administrative privileges.

Resolution: Grant rights to the administrator. Follow these steps:

Step 1: Go to Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Surface Area Configuration.

Step 2: Click on 'Add New Administrator'.

Step 3: In the 'SQL Server User Provisioning on Vista' dialog box, look out for the 'Member of the SqlServer SysAdmin role ' in the 'Available Privileges' box. Transfer it to the 'Privileges that will be granted to' box. Click Ok.

Note: You will be able to see 'Add New Administrator' in the Configuration tool only if you have logged in as an administrator SECOND:

After this run the "cmd"

"C:\\Program Files\\Microsoft SQL Server\\90\\Tools\\Binn\\"sqlcmd -S .\\BWDATOOLSET -E -Q "RESTORE DATABASE bw_dragonage_content FROM DISK = 'C:\\Program Files\\Dragon Age\\tools\\dbbak\\bw_dragonage_content.bak' WITH MOVE 'bw_dragonage_content' TO 'C:\\Program Files\\Dragon Age\\tools\\toolssql\\Data\\bw_dragonage_content.mdf', MOVE 'bw_dragonage_content_Log' TO 'C:\\Program Files\\Dragon Age\\tools\\toolssql\\Data\\bw_dragonage_content.ldf'"

This is it.
These Two things I did startet the Toolset without problems. The key is the First point

[Jazpar]

I do step 3 and click ok, but it wont stay in the 'Privileges that will be granted to' box. When I open it again its back in Available box. This didn't work form me.

[sirkaracho]

i have the same problem, i am running it on xp, but the priviliges are back in the other box

[Silas TNA5CoDe]

click on the 'Member of the SqlServer SysAdmin role , then on the single arrow and thus push it over to the other side, click OK

[sirkaracho]

we already did put the priviles from the left box into the right box, what we ar saying is: "it doesnt work for us"



it doesnt stay there, if we open it up again its all back in the left box

[Narial]

i have this problem and i'm not on vista. just one day decided to give the cant connect to database error, and manually strating the database in sql wont work at all



having to compeletely reinstall the game every day is getting OLD. part of me thinks this is tied to the 1.01 patch however and when i'm done raging against the machine, i'll try another reinstall and just not patch.

[Alkoholi]

Its weird, SQL does the database no problem, my privilidges don't stay in the box and I can't connect to database. Got the new patch installed I wonder if its the problem..

[sirkaracho]

i am not on vista, i didnt install the patch, i got the problem

[KaneHellgater]

Same problem here. I use XP SP3 and the 1.01 patch installed. Any solution?

[KREUGER44]

All I get when doing that is a message >  Client unable to establish connection due to prelogin failure

How should I solve this...

[KREUGER44]

Doug-Le-Guedin wrote...

 Trust in a release of a new version for the Toolset !

 please....

[Radimov]

Is imposible to solve... Bioware Solution please!!! at least an answer...

[adembroski11]

The Unable to Connect to Database symptom has a lot of diseases. I had it, it took me a while ti find the correct one. I think I might put together a thread with a collection of resolutions that are scattered throughout the forum tonight when I get home from work. Maybe we can convince the mods to sticky it.

[top_doggy]

Tried everything listed on the forum and the wikis nothing works !



BioWare are you working on a update for the toolset ??

[Silas TNA5CoDe]

Toolset is running and doing well for me, I sincerily dont know what the problem is, it seems that everybody has his OWN problem with it.

One thing that came into my mind: Have you all changed the status of the DATA Folder so that one can modify it? (Rightclick, File approval)

[maikanix]

I didn't have this problem before, but I ran a few updates just now, and now I can't access the toolset. And I can't connect to the server using the SQL management studios. I obviously have no idea what I'm doing, but I swear >.> I didn't touch anything. I was using the toolset before I updated.

[maikanix]

Also, I can't add myself like you suggest. I get an error.
I'm going to reinstall the toolset and see if that helps.

Modifié par maikanix, 12 novembre 2009 - 12:36 .

[Radimov]

Bioware has given an answer yet? It is outrageous that they say unless they are working on it.

[dlld77]

Note: im directly translating from swedish so no idea if they are called the same in the english version. Running vista 64bit.



Just fixed it, The way i did it was right clicking the data folder(in toolssql)>properties>security tab in there i have a few names find the one that is called User(whatever you named your computer or user name I think\\user) click it and see if you are missing full access then click the edit button and just add them all on that account.



Then either do the code or if you have problems with the path finding just reinstall the toolset since the installer uses the exact same code anyway i did the reinstall way.



http://img21.imagesh.../7907/toolc.jpg

[MastokkDA]

This solution seems not working on windows XP :/



There is no security tab on folder.