Register for your free account! | Forgot your password?

You last visited: Today at 08:19

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



SQL Problems

Discussion on SQL Problems within the Shaiya Private Server forum part of the Shaiya category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Feb 2010
Posts: 37
Received Thanks: 1
SQL Problems

Im on my way to create a new server but i ran into some problems.
Its when im attach to the database, i can attach with the windows authentication but with SQL authentication i get this error trying to attach: TITLE: Microsoft SQL Server Management Studio
------------------------------

Attach database failed for Server 'LUCAS-PC'. (Microsoft.SqlServer.Smo)

For help, click:

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Unable to open the physical file "C:\shaiyaserver\DATABASE\PS_Billing_Data.MDF" . Operating system error 5: "5(Access is denied.)". (Microsoft SQL Server, Error: 5120)

For help, click:

Since i can attach with Windows Authentication i bet its something wrong with the account somehow, And yes i have read the error.

Thanks in advance
- Lucas
lullerock12 is offline  
Old 05/09/2013, 12:44   #2

 
{Skrillex}'s Avatar
 
elite*gold: 0
Join Date: Mar 2013
Posts: 849
Received Thanks: 407
Is that only by this Database?
{Skrillex} is offline  
Old 05/09/2013, 12:51   #3
 
elite*gold: 0
Join Date: Feb 2010
Posts: 37
Received Thanks: 1
What do you mean? This happens right after i hit ok after adding the files to Database
lullerock12 is offline  
Old 05/09/2013, 18:03   #4
 
JohnHeatz's Avatar
 
elite*gold: 150
Join Date: Apr 2010
Posts: 9,739
Received Thanks: 8,977
He is asking if PS_Billing_Data.MDF is the only one showing this error, or if you weren't able to attach any of the databases to SQL.

I'd suggest first, running SQL as administrator, second, check your SQL Login credentials, see if you are connecting with a user that has all of the rights, and then, if nothing else helps, download a different set of databases.
JohnHeatz is offline  
Reply

Tags
attach, database, sql


Similar Threads Similar Threads
Roc Mountain Teleport Problems? DC Problems?
12/11/2011 - SRO Private Server - 1 Replies
I have got a problem to the teleport to Roc Mountain? (to aircraft dock and reverse scrool, non of them can teleport me to the Roc mountain inside area) In my database when Roc Mt. value is (2), i don't teleport here. It is true. When value is (1), i can teleport. It is true too. But when I change the value 2 to 1 the DC problem is arises. When i try to summon a attacker pet or i try to mount a vehicle (all of them can occur same problem) the dc problem is happen. Also some times when i...
Roc Mountain Teleport Problems? DC Problems?
12/08/2011 - Silkroad Online - 0 Replies
I have got a problem to the teleport to Roc Mountain? (to aircraft dock and reverse scrool, non of them can teleport me to the Roc mountain inside area) In my database when Roc Mt. value is (2), i don't teleport here. It is true. When value is (1), i can teleport. It is true too. But when I change the value 2 to 1 the DC problem is arises. When i try to summon a attacker pet or i try to mount a vehicle (all of them can occur same problem) the dc problem is happen. Also some times when i...
5165 Problems! 2 problems!
02/28/2010 - CO2 Private Server - 8 Replies
Okay so NOW I get these 2 problems in ma command prompt window of ma source... 2 problems: I really need help since I dunno wtf is the problem on 1 and 2...I'd appreciate it!
[Problems] Source 5165 All Problems
11/28/2009 - CO2 Private Server - 7 Replies
Hello Everyone, Ok i will put All my problems here So i hope noone spamming and Say Go learn C# and w/e 1-RegPage: fixed all by adding  to the start of the pass and  to the end of the pass. its working okay and when i create character and try to rejoin the game close with itself Note: When i make From NewestCOServer Cmd it works fine and the game dont close i mean i want other players to make thier own accounts and dont ask me to make them The Accounts they want. 2-Lottery: Cant...
[Problems]Having problems in Cabal Wudijt
07/01/2008 - Cabal Online - 0 Replies
1>im having problems in registering in Wudijt can anyone help me give me working link 2>i cant seem to update my red cabal online is it offline? 3>when i load Cabal.exe the cabal window will just dissapear please help me,i followed everyone's advice but it doesnt work, can anyone tell me what the real problem? thanks! ^_^



All times are GMT +2. The time now is 08:19.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.