Hi,
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
We 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
I 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.
Being 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
This 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
Hi 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
I am getteing
need help
Query analyzer error Unable to connect server local Msg17, level 16,state 1
ODBC SQL server driver [DBNETLIB]SQL server does not exist
Hi,
I've been trying to fix this error for two days! and I really need the advice of the experts please!
Computer XP Professional Service Pack2, SQL Server 2005 and Visual Studio 2005 (both Standard Edition)
ConnectionString:
<connectionStrings>
<add name="MyConnectionDB" connectionString="Data Source=(MyServerSqlServer2005);Initial Catalog=MyDB;User ID=sa;Password=PasswordforSA" providerName="System.Data.SqlClient" />
</connectionStrings>
C# code
string myConnectionString = ConfigurationManager.ConnectionStrings["MyConnectionDB"].ConnectionString;
SqlConnection myConnection = new SqlConnection(myConnectionString);
myConnection.Open();
Here I get the error: {"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)"}
What I checked so far:
ServerName and Instance Name OK!
Database, Username and password OK!
SQL Server 2005 Surface Are Configuration - Remote connections using both TCP/IP and Pipe Names OK!
SQL Configuration Manager - Protocolos Enabled (TCP/IP, Pipes, shared) OK!
SQL Server Browse running and active OK!
Am I missing something? I never had this problem with SQL Server 2000 and Visual Studio 2003.
Thanks in advance for any help or suggestion you can give me.
Sasa
Hi All, first post.
I have done a bit of searching around and cant find a clear answer to this question.
Current Setup
Desktop application (c#) that connects to a SQL Server 2005 express database on the same local network as the application (currently 3 users)
It is only a very small company and has just taken on their first remote worker, but expects to take on another 6-8 over the next few months. They have asked for the database to be moved online.
The application was written in such a way that everything has been done using no stored procs, or views, it is all native SQL.
This will be my first DB hosted online and before I go ahead and do anything I just wanted to make sure what I have to do is correct, sorry if this is a very basic question, although I have been programming for a long time, I have never had the chance to do any online databases before.
Will this work.
1.Find a SQL Server 2005 Hosting company.
2.Move the database to the server.
3.Setup the users permissions.
3.Alter the connection string in the application to point to the new location.
So the only thing that would change would be a new connection string in the application preferences?
Or am I living in a dream world, because nothing is ever that simple.
One thing I am worried about is the security/visiblity of the database and data as it travels from the server to the client and back.
Thanks for any advise you can give.
Mark
I'm a web developer who writes transact-SQL to make my web applications run properly. I'm not real strong in other areas of SQL. Let me explain our set-up and then I'll explain what I want to do:
We have an ecommerce web site and all sales are saved in a SQL Server 2008 R2 database at our hosting company. We also have a local Windows 2012 network that has SQL Server 2014 Express installed.
Here is what I want to do:
I want to copy sales rows from the SQL Server 2008 database at our hosting company and save them in the SQL Server 2014 Express database on our local Windows 2012 server. I'd like to automate this if possible so that it happens each night perhaps. I know there is a way to schedule SQL jobs but I've never actually done this. I also would need to know how to attach to our hosting company DB as well as our local network DB.
Hello,
I just installed SQL Server 2005 Enterprise edition from my company's DVD. It was installed with the setting of using both Integrated windows authenitication as well as basic named authenication. I installed all the options too: Database Engine, Analysis Services, Reporting Services, SQL Server compact edition, and Integration Services. When I look at services there are: SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services, and SQL Server Browser. All of which are running. Something that took me offguard was the installation did not ask me to provide an SA password. Other than that, the install looked like it went good.
I was able to connect to the local instance of the SQL Server 2005 using the SQL Server Management Studio. I could connect with SA, or connect with Integrated Windows Authenication. Whoohoo. Off and running! As a matter of fact, for the SA account I could use any password and it would still log me in.
First thing I did was I went in to the copy wizard to attempt to copy a database from a server on our network to my local box. First it asked me for the remote server. Then when I specified my local instance in the wizard, the wizard complained that my local instance was NOT SQL Server 2005. Doh! This I didn't understand. I figured maybe I need to check for MS updates. Sure enough, I found that ther was a SP2 and then a hot-fix for that SP2. I applied both. Now I cannot connect from SQL Server Management studio to my local instance of SQL Server 2005 database server. I get the following error:
"An error 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)"
However, I went in to see what other services I could connect to, and here's the results:
Analysis Services : OK!
Reporting Services (Windows Auth/Basic/Forms) : NG "The reporting Services Instance could not be found (Microsoft.SqlServer.Management.UI.RSClient)"
SQL Server Compact Edition : NG "The database cannot be found. Check the path to the database. [ File Name = CCG092 ] (SQL Server Compact Edition ADO.NET Data Provider)
Integration Services : OK!
I can connect to other SQL Server databases on our network. However, just not my local one. No one on the network can connect to me either.
I even turned off my windows firewall and still no luck connecting to my own.
So something really went wrong when I applied SP2, however, admittedly from the error message when I tried to use the copy wizard, something was probably already wrong.
Any ideas?
Thanks!
Hi,
I've been trying to fix this error for two days! and I really need the advice of the experts please!
Computer XP Professional Service Pack2, SQL Server 2005 and Visual Studio 2005 (both Standard Edition)
ConnectionString:
<connectionStrings>
<add name="MyConnectionDB" connectionString="Data Source=(MyServerSqlServer2005);Initial Catalog=MyDB;User ID=sa;Password=PasswordforSA" providerName="System.Data.SqlClient" />
</connectionStrings>
C# code
stringmyConnectionString = ConfigurationManager.ConnectionStrings["MyConnectionDB"].ConnectionString;
SqlConnection myConnection = new SqlConnection(myConnectionString);
myConnection.Open();
Here I get the error: {"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)"}
What I checked so far:
ServerName and Instance Name OK!
Database, Username and password OK!
SQL Server 2005 Surface Are Configuration - Remote connections using both TCP/IP and Pipe Names OK!
SQL Configuration Manager - Protocolos Enabled (TCP/IP, Pipes, shared) OK!
SQL Server Browse running and active OK!
No Firewall
Am I missing something? I never had this problem with SQL Server 2000 and Visual Studio 2003.
Thanks in advance for any help or suggestion you can give me.
Sasa
I found that when I install MSDE, then I can create/edit database objects for MSDE database in Visual Studio 2003 Server Explorer, but when I try to create/edit database objects under the default database created by the SQL Server 2000 installation, I cannot do these tasks as no option for these tasks appear when I right-click on the database object in Server Explorer. Anyone knows why this is happening?
View 3 Replies View RelatedCan't connect to local server instance MSSQLSERVER in SQL Server Management Studio (SQL2005 sp2/Vista).
SQL Server Configuration Manager reports SQL Server2005 services: SQL Server (MSSQLSERVER) Running. This would indicate the name of the SQL server is "MSSQLSERVER" correct? I chose "default" instance during the install and that is the name it gave itself.
I tried connecting to the server using the following for the Server Name: MSSQLSERVER and .MSSQLSERVER neither works.
The only thing that works for my installation is just plain "." (no quotes) and nothing else. Can this be correct because I can't find any reference to this. Thanks.
I'm creating an app and have SQL Server 2005 Express installed. Most of the hosts now offering SQL Server 2005 are a bit pricey compared to those only offering 2000. Will I have any difficulty uploading my site and running the db on SQL 2000? Thanks in advance.
View 3 Replies View RelatedHi,
I would like to join two tables: one on a local server which I have admin access to and another server which I only have read access. The local table is very small, but the remote table is very large.
If I look at Query Analyzer's execution plan, it appears that the join will be done locally (i.e. the entire table is transferred from the remote server and then joined to my local table). Is there a way to create a temp table using linked servers, transfer my small local table to the remote server and then perform the join on the remote server? In the past, I have been able to use openquery to restrict the data to a small subset that is transferred but the local table is a little too large for that.
I appreciate any advice / guidance anyone can offer me!
Hi all,
I have the following select that is designed to compare values on parallel servers.SELECT TA1.EPS, TA1.Sales, TA1.Income, TA1.EarningsReportDate,TA2.EPS, TA2.Sales, TA2.Income, TA2.EarningsReportDate
FROM TradeAnalysis.dbo.SalesIncome_Quarterly AS TA1
FULL OUTER JOIN L_TA_MIRROR.TradeAnalysis.dbo.SalesIncome_Quarterl y AS TA2
ON ((TA1.OSID = TA2.OSID) AND (TA1.QtrYear = TA2.QtrYear) AND (TA1.QuarterNo = TA2.QuarterNo))
WHERE(BINARY_CHECKSUM(TA1.EPS, TA1.Sales, TA1.Income, TA1.EarningsReportDate) <>
BINARY_CHECKSUM(TA2.EPS, TA2.Sales, TA2.Income, TA2.EarningsReportDate))Disregard the full outer join, it is necessary in the full select, I have just pared it down to show here and for testing. A standard join will also have the same result.
The trouble is that the comparison (the BINARY_CHECKSUM) is failing on the EarningsReportDate column, which is defined on BOTH servers in DUPLICATE databases as a smalldatetime.
The data is actually the same in both rows of each table (as is all the other data being compared). What I am seeing is that the select returns milliseconds on the LINKED server (the L_TA_MIRROR reference), but not on the local database?
for example,
Local server data returned in above select is 2000-01-28 00:00:00
Linked server data returned in above select is 2000-01-28 00:00:00.000
Wassup with THAT? If I remove the date from the select/comparison, it says everything matches, so I am pretty sure this is the culprit that is causing the BINARY_CHECKSUM comparison to fail.
Is there some setting that I need to put on the Linked Server reference that says "treat this as the smalldatetime data type it IS, dammit!"????
I can get by the issue if I replace the date reference in the linked server part of the select with CAST(TA2.EarningsReportDate AS smalldatetime) but why do I have to do this?
Yes, I am SURE both servers have the column in question defined as a smalldatetime, as running the same select on either server causes the same failure, but only when referencing the LINKED server column.
I want to create a database on my local machine and work with it. But I am not able to see the name of my local server under "Database Engine" in the list of "Registered Servers".
Options I tried:
(1) In Registered Servers window, On Database Engine, I right clicked and in that selected "Update Local Server Registration"
(2) In Registered Servers window, On Database Engine, I right clicked and in that selected "New" -> Server Registration.
In "New Server Registration" Window, in "Server Name" drop down I clicked "Browse for more" but still in "Browse for Servers" window, I am not able to see the name of my local server in "Local Servers" tag under Database Engine.
(3) If I do File -> Connect Object Explorer -> Connect to Server window in "Server name" drop down box, if I click "Browse for more", I am able to see local server name eg. "XYZ" under Analysis Services, Reporting Services, and Integration Services but not under "Database Engine"
Please help me create a new database engine in SQL Server 2005 or list my local server under "Database engine" ?
Thanks
I have just started looking at using a database with my web site. If I have SQL Server Express with the Advanced Services on my local machine and I use it to make interactive pages, can I use the schema and tables on the actual web site on a remote server? If so does that server need to have SQL Server Express installed too?
A link to a tutorial or reference that goes into some detail would be awsome!
Thanks everyone!
Hi Listers
I am using sql7 on both servers
i would like to run a stored proc(which has a distributed query) as a job from my local server on a remote server.This proc checks for info on the local server zzdb and remote server xxdb for updated fields.
This info is then inserted into yydb.The stored proc is defined on the yydb.
I have set up the linked server and login.The services is using the local account.The master and target server will not serve my purposes as this job is defined on the local machine and needs to be run from the local machine.
this job fails? any help will be appreciated
TIA
I try to copy database from remote SQL Server(6.5) to our local
SQL Server(7.0). I try this way: First, in Enterprice Manager,
I try "NEW SQL SERVER REGISTRATION" using "Register SQL
Server wizard". The remote server give me the IP, login name
and password. then, I try connect option by "login using
SQL Server". But I got message say:"specialted server not found,
Connection open,create file". some times say:"client server access
denied..." some times say:"timeout". What's going on here?
So, I can not get going on with "Import data wizard".
Does anyone know how to solve this problem? Any answer would be of great assistance!
Thanks
I need to figure out a way to copy .txt file from ftp server in local server directory using sql jobs.
View 4 Replies View Related Can I use SQL_Mobile as PC desktop server or PC local cache server?
I want many data to be cached at user's PC,
and call for this data to be created transparently as for remote
main SQL server.
Is it possible to do without creating complex structure of doubling functionality
of main queries to single SQL server ?
some articles, samples, links, keywords ?
thanks you
Hi..
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
Hi,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 RelatedI have recently installed sql 7 on a local PC (Desktop version), i am unable to register it.
i get a illegal operation evvery time . When i tried to create a DSN , It did not recognize my server. I do not have a network card in my system.
please help
vineet
I have a SQL2K server installed , and it is given an instance name (like BoxSQLInstance). I have a connect string looking for "local" server, is it possible to make this instance name as the default local server ?
View 1 Replies View RelatedI folks. I have something going on with my local SQL instance. It's SQL 2000 Standard with SP3a on a W2k3 Server with SP1. It's been running fine for several months. I got brave over the weekend and broke something.
I installed the .Net Enterprise Architect and SQL Reporting Services. My SQL instance is still running, but I can't get to it through EM and SQLServerAgent won't start. When I try to start SQLServerAgent manually, it gets about halfway through the process, then shuts itself down again. I also have an MSDE instance that is not complaining at all.
I can get to the server from my applications. I can also register it in EM with the IP and get to it that way.
Here's what's in sqlagent.out:
2007-01-02 16:34:41 - ! [298] SQLServer Error: 6, Specified SQL server not found. [SQLSTATE 08001]
2007-01-02 16:34:41 - ! [298] SQLServer Error: 11004, ConnectionOpen (Connect()). [SQLSTATE 01000]
2007-01-02 16:34:41 - ! [000] Unable to connect to server '(local)'; SQLServerAgent cannot start
2007-01-02 16:34:42 - ? [098] SQLServerAgent terminated (normally)
I did confirm in the registry that the port is set to 1433. It's not blank or incorrect. I am also working with a local account that is in the administrators group. There is no AD structure at work.
Many thanks for any ideas. This one feels like a little needle in a big haystack.
Eagles
Can someone please point me to some code (preferably C#, but C++ or C or VBwill work) that will detect if the (local) instance of SQL Server isrunning on a machine or not? Many thanks!-- Rob
View 2 Replies View RelatedHi,I am new to the mysteries of SQLDMO.I have written a program whereby the user can select which SQL serverto connect to on the Network and this works fine.I am using the SQLDMO.Application.ListAvailableSQLServers routine andthis works fine.However, the Server on the users machine appears as 'Local'I need to display the server name as the actual server name instead of'Local'Any ideas how to do this with SQLDMO.I know I could delve into the registry and get the name from there, butI want to avoid this.CheersAlex
View 2 Replies View RelatedHi,
I'm a little new @ this SQL Server technologhy...can someone please advise why is it better on install an instance of SQL Server on your local machine than have everyone remote into the server (production, test, development box)?
Thanks in advance.
Natalie
Dear All,
"SQL Server does not exist or access denied "
I got this msg when using (local) server to connect my database in my local pc, but if change (local) to my pc name the error fixed.
But I have a question, why sometimes we can just use (local) server for localhost but sometimes we need to change to pc_name or server name?
I have SQL Server Management Studio. I can access some databases to which I have been given access to. How can I create a sample database to which I can upload excel files as data fields.
This is for testing purposes. Any help appreciated.
Kiran