Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Coding Corner
You last visited: Today at 16:41

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

Advertisement



[Guide]Srevolution Full Guide Mssql + Mssql Server Manager + Server Files

Discussion on [Guide]Srevolution Full Guide Mssql + Mssql Server Manager + Server Files within the SRO Coding Corner forum part of the Silkroad Online category.

Reply
 
Old 11/01/2010, 17:56   #121
 
3lyka's Avatar
 
elite*gold: 0
Join Date: Feb 2008
Posts: 649
Received Thanks: 320
Lol its so sad cuz no 1 read guide...and ask about how and wher....all u can see in in guide why u spam with lame errors
3lyka is offline  
Old 11/01/2010, 18:04   #122
 
xFlyer's Avatar
 
elite*gold: 0
Join Date: Jul 2007
Posts: 215
Received Thanks: 30
Quote:
Originally Posted by 3lyka View Post
-
What REV is inside?
xFlyer is offline  
Old 11/01/2010, 18:13   #123
 
3lyka's Avatar
 
elite*gold: 0
Join Date: Feb 2008
Posts: 649
Received Thanks: 320
Quote:
Originally Posted by xFlyer View Post
What REV is inside?
33...In the end of guide u can found how download from svn ...
3lyka is offline  
Old 11/01/2010, 20:29   #124
 
elite*gold: 0
Join Date: Aug 2009
Posts: 39
Received Thanks: 2
Login Server Problem

Hello i got a Problem



Uploaded with


Quote:
@Loginserver: Server loading configurations...
[20:26:26] @Loginserver: Error:Fehler bei der Anmeldung für den Benutzer
'sa'. Der Benutzer ist keiner vertrauenswürdigen SQL Server-Verbindung zugeordne
t.
[20:26:26] @Loginserver: Database:.Net SqlClient Data Provider
[20:26:26] @Loginserver: Error:ExecuteNonQuery erfordert eine geöffnete u
nd verfügbare Connection. Der aktuelle Status der Verbindung ist 'Geschlossen'.
[20:26:26] @Loginserver: Database:System.Data
[20:26:26] @Loginserver: Error:ExecuteNonQuery erfordert eine geöffnete u
nd verfügbare Connection. Der aktuelle Status der Verbindung ist 'Geschlossen'.
[20:26:26] @Loginserver: Database:System.Data
System.InvalidOperationException: ExecuteReader erfordert eine geöffnete und ver
fügbare Connection. Der aktuelle Status der Verbindung ist 'Geschlossen'.
bei System.Data.SqlClient.SqlConnection.GetOpenConnect ion(String method)
bei System.Data.SqlClient.SqlConnection.ValidateConnec tionForExecute(String m
ethod, SqlCommand command)
bei System.Data.SqlClient.SqlCommand.ValidateCommand(S tring method, Boolean a
sync)
bei System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior cmdBeha
vior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResul
t result)
bei System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior cmdBeha
vior, RunBehavior runBehavior, Boolean returnStream, String method)
bei System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior behavior,
String method)
bei System.Data.SqlClient.SqlCommand.ExecuteReader()
bei Framework.MsSQL.Read()
bei Data.Base.Load_NewsList()

in English

Quote:
Login @ server: Server loading configuration ...
[20:26:26] @ server log: Error: Login failed for user
'Sa'. The user is not trusted SQL Server connection supplied arrange
t.
[20:26:26] @ Login Server: Database:. Net SqlClient Data Provider
[20:26:26] @ server log: Error: ExecuteNonQuery requires an open u
nd available Connection. The current status of the connection is 'closed'.
[20:26:26] @ Login Server: Database: System.Data
[20:26:26] @ server log: Error: ExecuteNonQuery requires an open u
nd available Connection. The current status of the connection is 'closed'.
[20:26:26] @ Login Server: Database: System.Data
System.InvalidOperationException: ExecuteReader requires an open and VER
Connection availability. The current status of the connection is 'closed'.
at System.Data.SqlClient.SqlConnection.GetOpenConnect ion (String method)
at System.Data.SqlClient.SqlConnection.ValidateConnec tionForExecute (String m
ethod, SqlCommand command)
at System.Data.SqlClient.SqlCommand.ValidateCommand (String method, Boolean a
sync)
at System.Data.SqlClient.SqlCommand.RunExecuteReader (CommandBehavior cmdBeha
Vior, RunBehavior RunBehavior, Boolean returnStream, String method, DbAsyncResul
t result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader (CommandBehavior cmdBeha
Vior, RunBehavior RunBehavior, Boolean returnStream, String method)
behavior at System.Data.SqlClient.SqlCommand.ExecuteReader (CommandBehavior,
String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader ()
at Framework.MsSQL.Read ()
at Data.Base.Load_NewsList ()
This was in my Database.ini

Quote:
[SREVOLUTION_DATABASE]
connectionstring=Data Source=V-294BFF4A5D344\SQLEXPRESS;Initial Catalog=DATABASENAME;User Id=sa;Password=1234;MultipleActiveResultSets=True;
Can anyone help me?
Joni7654 is offline  
Old 11/01/2010, 20:31   #125
 
3lyka's Avatar
 
elite*gold: 0
Join Date: Feb 2008
Posts: 649
Received Thanks: 320
Quote:
Originally Posted by Joni7654 View Post
Hello i got a Problem



Uploaded with





in English



This was in my Database.ini



Can anyone help me?
Initial Catalog=silk

when u connect to MSSQL MANAGER try connect with sa use for check
3lyka is offline  
Old 11/01/2010, 20:34   #126
 
madutz1's Avatar
 
elite*gold: 0
Join Date: Nov 2008
Posts: 375
Received Thanks: 32
anyone can give me last version ? full patch .. pls
madutz1 is offline  
Old 11/01/2010, 20:35   #127
 
elite*gold: 0
Join Date: Oct 2010
Posts: 192
Received Thanks: 48
Quote:
Originally Posted by Joni7654 View Post
Hello i got a Problem



Uploaded with





in English



This was in my Database.ini



Can anyone help me?
SREVOLUTION_DATABASE]
connectionstring=Data Source=V-294BFF4A5D344\SQLEXPRESS;Initial Catalog=Silk;User Id=sa;Password=1234;MultipleActiveResultSets=True;


Try this settings
coderska is offline  
Old 11/01/2010, 20:37   #128
 
elite*gold: 0
Join Date: Oct 2010
Posts: 192
Received Thanks: 48
Quote:
Originally Posted by madutz1 View Post
anyone can give me last version ? full patch .. pls
Write this link:


Using TortoiseSVN[
TortoiseSVN is a convenient SVN client for Windows that integrates with Windows Explorer.
Tutorial
Go to Windows Explorer (hit WIN+E or right-click on the Start button and click Explore), and create a new folder in a location of your choice. You may want to name it something like "Mediawiki Repository."
Right click on that folder and TortoiseSVN -> Create repository here.
Right click on that folder again and SVN Checkout.
For the "URL of repository," put
The checkout directory should automatically populate to the mediawiki subfolder of your repository folder.
Click OK.
coderska is offline  
Old 11/01/2010, 20:45   #129
 
elite*gold: 0
Join Date: Aug 2009
Posts: 39
Received Thanks: 2
Hey thanks but now i got this problem :D

Quote:
Originally Posted by coderska View Post
SREVOLUTION_DATABASE]
connectionstring=Data Source=V-294BFF4A5D344\SQLEXPRESS;Initial Catalog=Silk;User Id=sa;Password=1234;MultipleActiveResultSets=True;


Try this settings
my new problem after using your Database.ini

Joni7654 is offline  
Old 11/01/2010, 21:27   #130
 
xFlyer's Avatar
 
elite*gold: 0
Join Date: Jul 2007
Posts: 215
Received Thanks: 30
Quote:
Originally Posted by Joni7654 View Post
my new problem after using your Database.ini

Put "[" at the beggining.
xFlyer is offline  
Old 11/01/2010, 21:29   #131
 
madutz1's Avatar
 
elite*gold: 0
Join Date: Nov 2008
Posts: 375
Received Thanks: 32
Quote:
Originally Posted by coderska View Post
Write this link:


Using TortoiseSVN[
TortoiseSVN is a convenient SVN client for Windows that integrates with Windows Explorer.
Tutorial
Go to Windows Explorer (hit WIN+E or right-click on the Start button and click Explore), and create a new folder in a location of your choice. You may want to name it something like "Mediawiki Repository."
Right click on that folder and TortoiseSVN -> Create repository here.
Right click on that folder again and SVN Checkout.
For the "URL of repository," put
The checkout directory should automatically populate to the mediawiki subfolder of your repository folder.
Click OK.
What is new in this version ?
madutz1 is offline  
Old 11/01/2010, 21:29   #132
 
elite*gold: 0
Join Date: Oct 2010
Posts: 192
Received Thanks: 48
Sorry i forgot the [

Change:
[SREVOLUTION_DATABASE]
connectionstring=Data Source=V-294BFF4A5D344\SQLEXPRESS;Initial Catalog=Silk;User Id=sa;Password=1234;MultipleActiveResultSets=True;
coderska is offline  
Thanks
1 User
Old 11/01/2010, 22:25   #133
 
elite*gold: 0
Join Date: Mar 2007
Posts: 62
Received Thanks: 9
server running perfect but when i want to connect i become fail message ,,1/2dasdasdkjajsd" what means that?
CaPpA is offline  
Old 11/01/2010, 22:43   #134
 
xFlyer's Avatar
 
elite*gold: 0
Join Date: Jul 2007
Posts: 215
Received Thanks: 30
Quote:
Originally Posted by CaPpA View Post
server running perfect but when i want to connect i become fail message ,,1/2dasdasdkjajsd" what means that?
Screenshot please.
xFlyer is offline  
Old 11/01/2010, 23:19   #135
 
elite*gold: 0
Join Date: Mar 2009
Posts: 2,693
Received Thanks: 3,160
new error

and on my game server

i get every server every where is working but mine not !

tried every thing even if reinstalling os what should i do
LastThief is offline  
Reply


Similar Threads Similar Threads
[Guide] Setup MSSQL for Personal PServers
05/17/2012 - Shaiya PServer Guides & Releases - 14 Replies
So I know there have been quite a few people having issues setting up mssql correctly to host their own private servers. I decided to post a video tut on how to set it up correctly for local use. This was done on Windows XP 32-bit and works on other OS as well. *Note* This configuration is based on personal home use, not for public servers. I do not condone the use of illegal public servers, you will have to figure out those settings yourself. ...
Hilfee!!!! Prob mit Server files Und Db MSSQL
10/23/2010 - Flyff Private Server - 1 Replies
Also ich weis nicht wie Ich die offi Files richtig einstellen Und ein fügen solll Und bei der DB Kann ich nix Machen muss mich einloggen und weiss nicht wie Ich bitte um schnelle Antwort Kann Auch Skype oda TW?? Pls Pls Antwort Gruß Fashiion
[GUIDE]ASP.NET error for MSSQL 20005
10/02/2010 - Cabal Guides & Templates - 0 Replies
After a couple hours i have figured out how to correct the ASP.NET. I don't know if anyone else is having a problem with it.... This is what you do, Click the start Icon. in the search box type in "intermgr" a screen like this should open http://i814.photobucket.com/albums/zz64/xvvhitecl oudx/inetmgr.jpg
How i find mssql server
08/28/2010 - Kal Online - 3 Replies
Mssql server funzt bei mir nicht das 2000 gar nicht mehr zum installieren das 2005-2008 kann man nirgends in der scheisse bei google downloaden ... hilfe bitte
Sql Server 200 /MSSQL 200 ?
08/26/2009 - Dekaron Private Server - 2 Replies
Hi where i can get Sql Server 2000 or MSSQL 2000 ? have any one a download link for me ?



All times are GMT +1. The time now is 16:42.


Powered by vBulletin®
Copyright ©2000 - 2026, 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 ©2026 elitepvpers All Rights Reserved.