Sp_addserver 'local'
Feb 19, 2004When I run this in the QA
SELECT @@SERVERNAME
i get
MachineNameInstanceName
why don't these commands work ?
sp_dropserver 'MachineNameInstanceName'
sp_addserver 'MachineNameInstanceName,'local'
ADVERTISEMENT
Sp_addserver
Jun 23, 2005Hi guys
I was busy renaming my server and sp_dropserver worked but when it tried to execute sp_addserver it threw an error saying the server already exists. why did this happen and how do i fix it so that @@SERVERNAME is equal to the server name (at the moment it is null).
Thanks
Nick
Probleme Sp_addserver
Sep 23, 1999Hello sir,
I have a error in replication. my server name is like that "encpc-emf"
But trying to install replication, the following error "Replication cannot be
installed as @@Servername null".
I am running Windows NT with Service pack 4 and SQL Server 6.5 .
I do this commande
sp_dropserver encpc-emf
->Msg 170 Level 15, State 1
Line 1 Incorrect syntax near '-'.
I do this commande
sp_addserver encpc-emf
->Msg 18482, Level 14, State 1
Unable to connect to site 'ENCPC4' because " is not defined as a remote server at the site"
I don't understand what does this mean's?
Please advice me..
Sp_addserver In SQL Server 6.5
Mar 21, 2001Hi,
I have 2 SQL Server 6.5 Servers. The first one is Server1 and the second one is Server2. On Server1 I have a database called DB1 and on Server2 I have a database called DB2.
I open up ISQL_w on Server1 and go to DB1. I want to select rows from a Server2 DB2.(Table2).
So I used sp_addserver to add a row to the sysservers table on Server1. (I did a SELECT * from Sysservers on Server1 to make sure that a row had been added.)
Then from ISQL_w on Server1(DB1) I executed the following command: SELECT * FROM Server2..DB2.Table2..It did not work. I tried SELECT * FROM Server2.DB2.Table2..It did not work. I tried SELECT * FROM Server2..DB2.dbo.Table2..It did not work.
Please tell me how I can access rows from Table2 (Which exists on Server2(DB2) from ISQL_w of Server1 (DB1)..
Thankx
KP
Sp_addserver And Replication Probleme
Sep 28, 1999Hello sir,
Thank you for the quick response to my first posting. The problem with the replication is stil present.
serv1 (name)=anc20
serv2(name)=anc15-def
when i execute this commande sp_addserver serv2 in serv1, i receive
this message:
go
-----------------------------*/
Msg 170, Level 15, State 1
Line 1: Incorrect syntax near '-'.
when i execute this commande sp_dropserver serv1 in serv2, i receive
this message:
go
-----------------------------*/
Msg 15190, Level 16, State 1
There are still remote logins for the server 'anc20'.
the execution of the procedure sp_helpsort in serv1:
go
-----------------------------*/
Sort Order Description
------------------------------------------------------------------
Character Set = 1, iso_1
ISO 8859-1 (Latin-1) - Western European 8-bit character set.
Sort Order = 52, nocase
Case-insensitive dictionary sort order for use with several We
stern-European languages including English, French, and German
. Uses the ISO 8859-1 character set.
Characters, in Order
------------------------------------------------------------------
! " # $ % & ' ( ) * + , - . / : ; < = > ? @ [ ] ^ _ ` { | }
~ ˙ * ? Ý " c Ś Ž Ş - r _ ř ń ý 3 ' ć ú , 1 § Ż Ź Ť _
¨ x ö 0 1 2 3 4 5 6 7 8 9 A=a A=
A=* A= A=a = ?= = B=b C
=c = D=d E=e E= ?= E= E= F=f G=g H=h I=i I=? I=Ą I= I= J
=j K=k L=l M=m N=n Ľ=¤ O=o O= O=˘ O= O=o = O=o P=p Q=q R=r S
=s á T=t U=u U= U=Ł U= =? V=v W=w X=x Y=y Y=y Z=z D=d _=_
The execution of procedure sp_helpsort in serv2:
go
-----------------------------*/
Sort Order Description
------------------------------------------------------------------
Character Set = 1, iso_1
ISO 8859-1 (Latin-1) - Western European 8-bit character set.
Sort Order = 52, nocase
Case-insensitive dictionary sort order for use with several We
stern-European languages including English, French, and German
. Uses the ISO 8859-1 character set.
Characters, in Order
------------------------------------------------------------------
! " # $ % & ' ( ) * + , - . / : ; < = > ? @ [ ] ^ _ ` { | }
~ ˙ * ? Ý " c Ś Ž Ş - r _ ř ń ý 3 ' ć ú , 1 § Ż Ź Ť _
¨ x ö 0 1 2 3 4 5 6 7 8 9 A=a A=
A=* A= A=a = ?= = B=b C
=c = D=d E=e E= ?= E= E= F=f G=g H=h I=i I=? I=Ą I= I= J
=j K=k L=l M=m N=n Ľ=¤ O=o O= O=˘ O= O=o = O=o P=p Q=q R=r S
=s á T=t U=u U= U=Ł U= =? V=v W=w X=x Y=y Y=y Z=z D=d _=_
The execution of procedure sp_helplanguage in serv1 and serv2:
go
-----------------------------*/
No alternate languages are available.
us_english is always available, even though it is not in syslanguages.
again Thank you in advance , your help in this matter is greatly appreciated
Tezniti
Local SQL Server Instances Not Showing Up On Local Servers Tab Of Management Studio Logon Screen
Oct 2, 2007We have a 64-bit VM server running SQL Server 2005. The SQL Server on this particular VM server has 6 local instances installed. On the Management Studio logon screen I can type the full name of the local instance and connect to it, however if I press the drop down in the Server name field, choose Browse and select the Local Servers tab there is nothing listed under Database Engines.
Any idea why the 6 local instances don't show up under Database Engines? This is preventing me from installing a vendor application because their installer looks for local SQL Server instances on this server, but if SQL Server won't even show the local instances then the installer doesn't see them either.
Any help is greatly appreciated.
Thanks,
Craig
Not Able To Connect To The Local Database With (local) As Server Name
Jun 7, 2006I am facing a problem in connecting to the local database with server name as (local).
I have installed SQL Server 2005 in my machine. When I try to connect to the SQL server with the server name as SUNILKUMAR I am able to connect but when I try to connect to the same server with the server name as (local) I am not able to connect. SUNILKUMAR is my machine name and SQL server is running locally.
if anyone can help me what is the problem in this case it is highly appriciated.
Need Help - Local Synchronization Between SQL Mobile And Local SQL Database
Dec 21, 2005Hi Everyone
I am at the stage of architecting my solution
My goal is to develop the system on a windows application and pda
There is a central server which will create a publication called inventory
The laptops which host the windows application will be subscribers to the central server using merge replication
The client now wants the PDA using SQL Mobile to synchronize with the local subscirber database on the laptop using active sync. They dont want to do it via WIFI to the IIS Server at the central server
I have been reading for days and I am still unsure whether this is possible to do.
I know Appforge provide a conduit for palm to access synchronization but not local sql databases
I would appreciate your help immensley
Moving A SQL Server 2000 Database From A Local Drive To Another Local Drive
Jan 31, 2008Being a very novice SQL Server administrator, I need to ask the experts a question.
How do I go about moving a database from 1 drive to another? The source drive (C is local to the server, but the target drive (E is on a Storage Area Network (SAN), although it is still a local drive for the server. I want to move the database from C: to E:. Can someone provide me with instructions?
Thanks,
Rick
Failed To Generate A User Instance Of SQL Server Due To Failure In Retrieving The User's Local Application Data Path. Please Make Sure The User Has A Local User Profile On The Computer. The Connection Will Be Closed
Dec 7, 2006This is my first time to deploy an asp.net2 web site. Everything is working fine on my local computer but when i published the web site on a remote computer i get the error "Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed" (only in pages that try to access the database)
Help pleaseee
Error On (local)
Aug 8, 2006An error occurred in the system, and last operation may not have completed: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
The above error I get when I like to connect to a db for a wiki. It's on localhost and everything I found on the internet I tried. Remote connections are not relevant because it's local. Have I something forgotten?? SQL Server 2005, Asp.net 2.0
Connect To Local
Sep 11, 2007Hey Guys,
I have a SQL connection string question. In my web.config I don't know what to put for the server. I have SQL Server 2005 installed locally.
<connectionStrings><add name="database" providerName="System.Data.SqlClient" connectionString= "server=whatgoeshere?;database=test;uid=sa;pwd=password" /></connectionStrings>
I'm using VS 2005.
Thanks in advance.
-Marc
Scheduled DTS On Local SQL 7
Mar 24, 2000I have a DTS that executes fine except when run as a scheduled event. Where can I research the error codes that occur below?
DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_10 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_10 DTSRun OnStart: Copy Data from FirmDirExp to [CG_Directory].[dbo].[FirmDirExp] Step DTSRun OnError: Copy Data from FirmDirExp to [CG_Directory].[dbo].[FirmDirExp] Step, Error = -2147008507 (80074005) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 700 Error Detail Records: Error: -2147008507 (80074005); Provider Error: 0 (0) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 700 Error: -2147467259 (80004005); Provider Error: -534709256 (E020FBF8) Error string: The Microsoft Jet database engine ca... Process Exit Code 1. The step failed.
Local Variable
May 27, 2004I am trying to create a procedure or function that will deal with weekly information for staff records.
Rather than declaring 14 local variables for the information, is it possible to declare a local variable as an array? Sorry for using VB terminology - not sure how SQL would describe it.
TIA
Fatherjack
Can Not Access Local DB
Mar 6, 2002I have a local SQL2000 instance on my PC and cannot get in. I am running windows 2000 with active directory. I used to open the database using windows authentication. I recently had to change my password. I do not know if this has anything to do with the problem. I have tried everything, using windows authentication, using my login with old password, login with new password, sa account. Does anyone know how I can get in or how I can remove this instance and create a new one?
Thanks,
Ken Nicholson
Local Server Name
Dec 13, 2004Hi,
I am trying to connect to my (local) server to get a list of databases on that server. It doesn't work when I pass (local) as the server name, but it works if I hardcode in the actual name. Does anyone know how to get the actual server name?
TIA,
Royce
Regarding Local Variables
Sep 25, 2006declare @Id integer
set @Id=1145
select '@'+'Id'
result: @Id
But I want the result to be 1145. Is it possible, If so please let me know how.
Thanks
Suresh
UTC V.s Local Time
Mar 7, 2007I am a newbie to SQL server. I have datetime values stored as UTC in a table. What I want is that when I retrieve the records it should display these datetime values in local datetime. IS there a query or procedure someone can help me with?
Also is there some way of inserting the records in local time instead of UTC.
nivea
Remote To Local
Jun 19, 2007I have a remote database on a server.
I am an authenticated user to a database on the server.
I want to get the data in the database to my local computer
I don't have a shell (or any other way) access to the directory
related to sql server
so what can i do to get a copy of the data?
Local Data
Jul 23, 2005I am implementing an MSDE database and I would like to keep some data(like user preferences) in the Access project so that I can filter datafor each user based on their selected preferences. In Access I justkept user preferences in the application database on each workstationand used queries to get only the data I wanted from the linked tables.How can I do this in MSDE/Access projects?thanks!Jerry
View 1 Replies View RelatedLocal DB Affected By VPN
Nov 27, 2007I work on a local copy of a database (Access 2000 MDB with ODBC linkedtables to a SQL 7 database). The SQL Server db I'm working with is on my Cdrive (MSDE). Occasionally I'll connect to a VPN to do something on a remotecomputer, using PC Anywhere to perform the task. Doesn't involve my front orback end at all, except that the computer I'm VPNing to has a SQL databaserunning.OK, so I'm using my db; I connect to the VPN, and do my thing. Everything'sfine. However, if I then disconnect from the VPN (or if the VPN connectiontimes out and disconnects itself), I then can no longer access my local SQLServer database. My Access application still works fine, as long as itdoesn't have to look at any data. When it does have to look at data, I getODBC call failed. I have to close and reopen my Access database, and theneverything is fine.So, it seems that, for some reason, when I connect to the VPN, my local SQLServer or the ODBC driver or something in the mix is looking at that remotedatabase as part of what I'm using. Then, when the VPN connection is closed,it won't access my local database for some reason.Oh, and my local database and the remote database both have the same name.So that may be part of the problem.Any ideas as to what's going on?Thanks!Neil
View 4 Replies View RelatedReplicate To Local Pc
Jul 20, 2005Hi !Hi !I'm thinking of installing a Microsoft SQL Server 2000 on a database server,to be the db of a webapplication, but the it must be possible for the usersto copy/replicate data from the server db, to a local db on their e.g.laptop to work even if not online. Is there a tool that can handle thisscenario. (it must be possible to update the server db from the laptop whenonline again ).And:What have to be installed on the laptop (apart from my application runningon the replicated data) ?Thanx/Hans
View 2 Replies View RelatedDomain Vs Local
Jul 20, 2005What are gotchas for starting Sql & the agent with a Local system accountversus a system Domain account.
View 3 Replies View RelatedCannot Connect To My Local Iis
Nov 7, 2007
hi..
i am trying to run my asp project using my iis in winxp and installed a sql express 2005 and wheni try to connect using http://localhost/myproject i encounter this error
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
am i missing some permission settings in sql express?
thanks
Local Reports
Nov 11, 2005Thanks for the info but I am interested in designing and running local reports in a windows form. I have not been able to find correct documentation on how you define a schema that can be used to create an rdlc file for design of a report that uses a datasource that is set at runtime. Specifically, I would like to use business objects that return a data table in a get method.
View 3 Replies View RelatedLocal IP Address....
Jan 29, 2008
Hi guys.
i know the funcation that v can use to get the local Machine Name '@@server' , it's return the server name
is it' possible that or is there any way to get the IP address of the Machine..
Thanks and looking forwrad.
-MALIK
Vista Local TCP/IP
Jul 19, 2007Hi !
I've some problem with Vista and SQL Server 2005 SP2. My apllication (Client) can fast and correctly working on Sql Server on the other host and Client from other host can fast work when connect to my Sql Server, but when I'm connecting localy my apllication is working horrible slow :/ What should I change in Sql Server configuration or Vista to make my application run fast locally ? So cause only one difference (in my opinion) is how Client is connecting with Sql Server (other PC's by TCP/IP and locally can connect with other ways like named pipe or shared memory) I've disabled in Sql Server Configuration Manager all protocols except TCP/IP but it've changed anything :/ Can somebody help me ?
By the way sorry for my bad English
From Local To Inet Server
Jun 25, 2006Hi..
First of all im a super newb in asp.net and MSSQL.I had a guy program a website with database, but the guy just stood me up and left me with the files and the server as a file.
Now I need to get them online and working.
The files are FTP on the server so I "just" need the server running
I got the following files:
Justgeek_data.mdf and Justgeek_log.ldf
The server admin interface is: myLittleAdmin.
Any walktrough help or simular would be highly appreciated.
The web is: http://www.bodyplanning.dk
I Can't Connect To My Local DataBase Please Help...
Sep 14, 2007
DBconn.cs
private DBConn() { // // TODO: ĺ¨é裥ĺ ĺ
Ľĺťşć§ĺ˝ĺź?çç¨ĺź?碟 // this.Server=Property.getProperty("DBServer"); this.port=int.Parse(Property.getProperty("DBPort")); this.User=Property.getProperty("DBUser"); this.Pwd=Property.getProperty("DBPwd"); this.db=Property.getProperty("DBDatabase"); this.ConnectionString="server=" + this.Server+","+this.port+";database="+this.db+";uid="+this.User+";pwd="+this.Pwd+";Connect Timeout=60"; }
--------------------------------------------------------------------------------------------------------
propetry.config
<property name="DBServer" value="127.0.0.1" /> <property name="DBPort" value="1433" /> <property name="DBDatabase" value="CSLC" /> <property name="DBUser" value="CSLCUser" /> <property name="DBPwd" value="resslc" />
I use this way to call my connecting string , but I can't connect to my local DataBase , I trid to modify the propetry.config to coneect to other DataBase on other Server it works
only when Connecting with my Local DataBase , it not work...
this problem have been troble me more than 3 weeks... ask many people no one can resolve this problem...
when I am at home . I can't work... because I can't connect to the Server when I'm in office..
pleaes help... thank you very much
Cannot Login To Web App From Local Machine But Can Over RDP
Oct 29, 2007See above. At first I thought it was a problem with SQL server, since I have just installed a new certificate. Now I am not so sure. Any suggestions???? Thanks, kreid
View 3 Replies View RelatedProblem With Local Connection
Nov 14, 2007I've just installed VS .NET 2005 and also installed sql Express that come along with itwhen I tried to run a simple web page wih gridview that connect to the sql express with the table that I create and test it status is "Tested connection suceeded" or test query is also successful but when I run I got the following message please help
---------------------------------------------------------------------------
Cannot open database "customers" requested by the login. The login failed.Login failed for user 'myServerASPNET'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Cannot open database "customers" requested by the login. The login failed.Login failed for user 'USFER54-8B481CEASPNET'.Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:
[SqlException (0x80131904): Cannot open database "customers" requested by the login. The login failed.
Login failed for user 'USFER54-8B481CEASPNET'.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +739123
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1956
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +170
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +349
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770
System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17
System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70
System.Web.UI.WebControls.GridView.DataBind() +4
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69
System.Web.UI.Control.EnsureChildControls() +87
System.Web.UI.Control.PreRenderRecursiveInternal() +41
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360
Thanks in advance for your help
Connecting To Local SQL Server
Dec 17, 2007Hi,I am having problems connecting to databases on my local SQL Server, express edition from my website.The following is the connection string i am using:Database=MyDatabase;Server=COMPSQLEXPRESS;User ID=sa;The error I get is "Login failed for sa"I have tried other users but no luck. Also, I cant seem to create a new user as I don't have administrators rights, any ideas how i can do this?Any ideas?
View 3 Replies View RelatedGet Database To Local Machine
Jan 29, 2008What is the fastest way to get a copy of a SQL server database on a server to my local Windows XP Professional system?
View 4 Replies View Related