I have the following command in a .bat file
osql -E -S localhost sp_grantlogin 'GREGASPNET'"
What I would like to do is replace GREG with the name of the local computer this .bat file is being run on.
Is there any string for this... i.e [LOCALMACHINE]ASPNET or something like that?
Greg
Hi All,
I have enterprise version software CD1 and CD2 of SQL server 2005
when i try to run setup.exe..the following error pops -up
The image file Setup.exe is valid, but is for a machine type other than the current machine
MY OS version is windows 2003 32bit Operating system...
I am suspecting the binarie may be of 64bit.. How do we check the binaries are 32 bit and 64 bit software
Thanks for your Help
Mohan
Hi, i wondered if anyone could help me with my stored procedure.
It updates a table with users messageboard and saves the Title, Line 1, Line 2 and so on into a XML thats stored in the column named XML_Data.
How can i then output this xml to a file on my local machine?
T-SQL :-
ALTER PROCEDURE [dbo].[prUpdateMessageBoardVetted]
(PARAMS GO HERE)
UPDATE CustomerData
SET Title = @Title,
Line1 = @Line1,
Line2 = @Line2,
Line3 = @Line3,
Line4 = @Line4,
Line5 = @Line5,
Line6 = @Line6,
XmlFileName = @XmlFileName,
FlashFileName = @FlashFileName,
HtmlFileName = @HtmlFileName,
Vetted = @Vetted,
ClientName = @ClientName
WHERE
(UserRef = @original_UserRef)
END
BEGIN
IF @Vetted = 1
DECLARE @xmlData AS XML
SET @xmlData = (SELECT
UserRef,
Title,
Line1,
Line2,
Line3,
Line4,
Line5,
Line6
FROM dbo.CustomerData
WHERE (UserRef = @original_UserRef) FOR XML RAW('Message'), ELEMENTS)
SELECT @xmlData
UPDATE [dbo].[CustomerData]
SET
XML_Data = @xmlData
WHERE
(UserRef = @original_UserRef)
(THEN HERE DO SOME SORT PROCEDURE TO OUTPUT @xmlData to a XML FILE ON MY LOCAL MACHINE,
BUT ALSO NAME THE XML FILE VIA @XmlFileName BY DOING SOME SORT OF CONCANTENATION)
any ideas?
Thanks in advance !
Neil
How to create a db in clients local machine with sql server ce and .net?Is any sample applications available?so,that later i can sync the data to the sql server db.
Please help.I am new to sql server ce.
Hello All
Just wondered if someone could help me with a bit of T-SQL, i have a application in ASP.NET/VB that allows the user to update a message board by clicking a button "update" this in turn triggers my Stored Procedure for inserting this data into a table, which works great.
It inserts the data into its respective fields and also takes The Title, Line 1, Line 2 and so on and creates a XML file (Using FOR XML) which is stored in the same Table under a column call XML_Data. Which again works great.
My problem now is how do i output this XML_Data to an actual XML file that is on my local machine, i.e. It be created in say C:Inetpubwwwrootxmlfiles("xml file name inserted here from another column that holds xml file name").xml
Any help on this would be greatfully apreciated
Thanks In Advance
Neil
I am running a number of SQL instances on my PC. Within the network, I have think server with various System Center components. For compatibility reasons, some features of System Center 2012 R2 had to be delegated to different SQL databases. My question is, because there is now more than one IP address on my system, and each instance of SQL is assigned to its own IP, is there a way to setup DNS and SQL so the namespace points to the desired IP address? For Instance:
MSSQL2008 instance is set to run on = 11.12.13.1
MSSQL2012 is set to run on = 11.12.13.2
IN DNS:
A Record: Mike-PC = 11.12.13.1
A Record: Mike-PC = 11.12.13.2
If I want to use MSSQL2008 by specifying Mike-PC as the DNS name, how would I do that with 100% accuracy? If there is another way to get the job done, I am more than willing to approach this differently.
We currently have the problem, that all our machines are produced with the
same name and afterwards the name is changed. So we have the problem that
the checksum key for the MSDE isn't valid anymore. As MSDE can only be installed
from unattended mode so I can’t rerun setup and fix the problem. Does anyone
know a solution for this problem ?? A program recalculating the cheksum ??
regards,
Manfred
See 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 RelatedWhat 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 RelatedHi
I need to change the Local Machine Name. But if I do that, my SQL server will stop working. Is there any way to fix the SQL Server?
Thanks in advance
Manish
I have SQL Server Express 2005. I have it configured for remote connections, but I cannot even see my local dbase. I have the server setup for windows authentication. In VB 2005 database connection wizard I see the db server but on the database itself.
When I click test connection....without a dbase choosen it says ( i don't have any to choose from).
"An error has occured while establishing a connection to the server. When connection 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"
This doesn't make sense because i have changed the the surface area configuration to allow remote connections on both TCP/IP and Named pipes. It shouldn't matter though because this is a local database.
Thanks
Kramer
I am getting the "Error Locating Server/Instance Specified" message. The part I find most confusing is that I am connecting to my database locally. I have read the recommendations on the blog posted here:
http://blogs.msdn.com/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx
and implemented them to no avail. The confusing part is that I only have this problem on one particular application, which I am not the original author of. When I build my connection to the very same server (different database) using the Data Source configuration wizard, it works just fine. Any help would be greatly appreciated.
Hi,
I have installed msde on a 98 machine and so far I have no problem getting the msde running. However, when I run my application, which tries to connect to the msde, it gives me two errors --
1.) Method "OpenConnection" of object "_CurrentProject" failed
2.) Couldn't find the database on the server. Object failed.
I have checked and the database name is correct. I have also installed MDAC 2.8 on that machine.
I am running out of ideas and hope that maybe somebody in the forum has seem this problem before and may be able to give me a hand.
Thanks
SHK
Hi SQL folks,
I've googled for this the whole yesterday and I couldn't find a complete solution.
I'm having a sql2005 database in my development machine and I need to copy all the content "Tables, Diagrams, PK columns and other data" to the remote production machine.
Using the Import/Export method didn't copied the relationships between tables, also it turned the PKs into just a standard columns
Can anyone help?
I have had a new PC and have installed SQL Server. However, I do not seem to have anywhere to create databases on my PC. I did on my old one. How can i do this ?
View 2 Replies View Relatedhello,
Sql server type: database engine
server name:
authentication: sql server authentication
login: sa
password: xxxxx
I remember the server name being sqlexpress (I think that was the default name during the install).
OR are they asking for my computer name? because I tried that also and it gave me an error saying "the default installation doesn't allow remote connections"
I have SQL Express running on my laptop but are unable to connect to the default database paulm-laptopsqlexpress
When I try to connect I get the error message
TITLE: Microsoft SQL Server Management Studio Express
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) (Microsoft SQL Server, Error: -1)
Everything is on my laptop whcih is running Vista Business as an administrator
Any ideas why,
Thanks Paul
Hi all,
Apologies if this is a dumb question, but I'm tearing my hair out over the basics when I should be spending time learning ASP.NET 2.0 and C#. I've searched the archives and a lot of people seem to be getting the same error as me, but when trying to connect from remote machines.
I'm getting what seems to be a standard message ...
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
I'm not trying to connect remotely, I'm on my developer machine. The error comes up when trying to connect from within VS2005 (Tools, Connect to Database). It also comes up if I create a new web-site and go to the ASP.NET configuration tool (this is, I guess, trying to create the necessary database behind the scenes but is unable to connect to the database).
I suspect the error might be related to one or more of the following ...
September last year I installed VS2005 Express and SQL*SERVER Express. Both were fully un-installed when I bought VS2005 Professional before installing the new product.
When I set up SQL*SERVER 2005 Developer I remember choosing an option to have a separate user on my PC with administrative rights. Actually I don't recall much about what I chose but I can't find out where those permissions are managed from.
I've followed various instructions to check that remote access is enabled (despite the fact that I'm local, not remote). TCP and Named Pipes are both enabled (and I stopped then restarted SQL Server). I've checked that the service is started.
The odd thing is that I have had an application connect with the following string ...
SSLCon = new SqlConnection(@"Server=(local)SSLMJ;Integrated Security = True;" + "Database=SSLTESTRESULTS");
Though the application connection seems to work ok, I think I'm missing out lots of developer functionality because I can't get VS2005 to see the database or server.
Help ?
Hello friends, I am a begginer in MySQL. Kindly guide me how can Iinstall and run MySQL server on my machine (Runnig Wnidows XPprofessional and SQL server 2000). Is it neccessary to remove SQLserver from the machine before installing MySQL and what version of IISis required? Kindly help me in this regard, it will be appreciated.Thanks in advance.
View 1 Replies View RelatedCan an individual computer be configured contain both a SQL Serverinstance & an MSDE instance?Our software we charge separate costs depending if they are running ona MSDE or SQL Server edition, and if they already have SQL Serverrunning (which they may have installed for some other application), canwe install our MSDE instance on the same machine?And on the flip side, if they already have a machine that has an MSDEinstance, can the SQL Server install be done over top of that withoutaffecting the MSDE?Thanks for any help,GregJoin Bytes!
View 1 Replies View RelatedCan I have MSDE and SQL2K installed on the same machine?
Thanks
Mary
Is it possible to run MSDE and Pervasive SQL on the same machine ?
If possible but not recommended I'd really appreciate the reasons why it should not be done.
If not possible I'd also really appreciate hearing why.
Thanks in advance.
how deploying a local database to target machine?
View 1 Replies View RelatedFirst of all let me explain that I am a complete newbie to this SQL stuff. I am in the process of reading a book, and followed the books suggestions for what I want to do, but it doesn't work. I know this has been covered several times in this forum, but no one post in particular covered exactly what I want to do.
I want to copy the database from the server to my local machine.
First, do I need to have SQL running on my machine in order to copy the database? I do have Enterprise Manager running, does that mean SQL Server is running locally?
Secoond, I tried using the Copy Wizard, but when I get to the target list, my local machine is not listed. How do I get it listed so I can copy the database?
I hope my questions are not too stupid... but then I'd be stupid if I didn't ask questions.
Thanks in advance for your help...
David
This may be a stupid newbie question, but being that I'm not a DBA I'm going to ask it anyway.
We discovered a problem with a clients server (Windows 2003 SBS) when we tried to install Veritas Backup Exec. Backup Exec requires an instance of either SQLMSDE or full SQL. This server has full SQL 2000 sp3a installed on it with a working account application. When backup exec trys to create it's instance it fails.
Investigating further...when I go into Enterprise Manager (logged in as Domain Admin) I get an error when I select the local server.
I.E.
"A connection could not be established to (LOCAL).
Reason: Data source name not found and no default driver specified.
Please verify SQL Server is running and check your SQL Server registration properties. blah blah blah.
Okay the server is running. The accounting application (client/server) is still working. I right click on the server and select "New Server Registration" for the field "server" I click the browse button and the "Active Servers" box is empty..:shocked:
I went to check the "Data Sources" under drivers, that field is blank. (no drivers installed). I downloaded MS's component checker and it says "MDAC 2.8 on Windows server 2003 sp1" is installed.
At this point I have exhausted my knowledge of MS-SQL server. My goal is to get BackupExec installed and NOT break the existing accounting application.
Any help is greatly appreciated.
Thanks
rogerb
Here is the connect tring from table properties:ODBC;DRIVER=SQL Server;SERVER=VICRAUCHSRVRVGSMISC;APP=Microsoft Data Access Components;WSID=VICRAUCH;DATABASE=vgs_prod;TABLE=d bo.USysCandidatesHere is the connect string from the ADO .Open connect string:"ODBC;DRIVER=SQL Server;SERVER=VICRAUCHSRVRVGSMISC;APP=Microsoft Data Access Components;UID=sa;PWD=xxxXX99X;WSID=VICRAUCH;DATAB ASE=vgs_prod"Here is the ADO .Open code. Set CNN = New ADODB.ConnectionDim strDEFConn As StringstrDEFConn = FixConnStr(DEFCONN)CNN.Open strDEFConn The last line fails with the CNN.Open strDEFConn with this message:Run-time error '-2147467259 (80004005)';[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified This code works when the SQL Server is on it's own server, but for testing at my own office, I have SQL Server on the same machine as the Access application. I'm getting the above error where SQL Server and the Access app are on the same machine. I can open a linked SQL table from the user interface, and VBA code that deals with the tables as Access tables works. It is the ADO .Open statement where the error happens. Thanks for any help you can give me on getting this to work.
View 5 Replies View Relatedhow to deploy web services on local machine. I created self certificate in IIS and then build the solution in the visual studio. After I build the solution, I found that automatically it created the virtual directories for the web services under the default website in the IIS Manager. When I click and select the browse it is not working.
View 9 Replies View RelatedI was trying to load SSIS shipped from my colleague. It has configuration file with his SSIS. I added this one to my local project. I removed configuration file from my project. In case anything goes wrong, I also delete OLE DB Connection String, and recreated one. Modified all data flow and control flow for any connection to point to my new one.
After the modification, it still fails on login 'sa'. I cannot figure out the problem. Is there any tricky inside of SSIS configuration file?
This is what I sometimes want:
I have installed on a localmachine sqlexpress. Also my application is installed on the local machine.
But for the night-backup of the database I want to put the database on the company server.
Let's say the database is on: X:datamydatabase.mdf
Why cant't I attach this database with the manager of sqlexpress
Second:
I have installed on local machine sqlexpress AND also the database
Why can't I backup the file to the server like:
BACKUP DATABASE [mydatabase] to DISK=x:datamydatabase.bak WITH FORMAT
It looks I can only backup to the localmachine.
thanks a lot
Klaas
Hi all of you,
Primary platform is Framework 2.0 running over XP.
I've got an issue with a SSIS package which uses Oracle Provider for OleDB:
Test connection failed because of an error in initializing provider 'OraOLEDB.Oracle.1' is not registered on local machine
Nevertheless, MS Ole DB Provider for Oracle works fine. Let me know where am I failing.
Thanks in advance,
I am trying to create CLR stored procedure in VS 2008. Within the procedure, I need to connect to an Informix database using the Ifxoledbc driver. We have other applications using this driver, so it wouldn't seem to be a probmlem with the driver itself. However, I get this error from SQL 2005 when I try to make a connection from my CLR code. It must have something to do w/ sql server, but not sure what. Any ideas?
Thanks for any help!
Rich
I have an interesting problem. I am running xp pro and when I try to connect to an instance of SQL2005 running on WIN2003 using SQL Sevrer Management Studio, I get the following 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: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) (.Net SqlClient Data Provider)
This instance is protected by a vpn and is running on a clustered environment. I can connect to other SQL2000 servers that are running on a clustered environment and SQL2005 that is not clustered.
After adding a host file entry, I was able to connect to the server using OSQL. I was able to telnet into the port the server is listening on.
Others in my group can connect to the server using SQL Server Management Studio with no problems. They are running Win2003 Server. I originally could connect to this server, but I needed to change my password. After that I lost my remote connectivity. I can RDP into the server and map drives to the server. I map to a local administrator of this machine.
I am not sure what else to try?
Help.
Hi all,
I started learning ASP .Net using the "Teach yourself ASP.Net in 24 hours". In that book, the applications use MSDE as the database tool.
Now i have started developing some big applications and have installled MS SQL Server 2000 on my machine.
I still have databases on the MSDE.
My question is 'How do i move the old databases from MSDE to SQL Server 2000' ?
Can i uninstall MSDE safely since i already installed SQL Server 2000 ?
Please let me know.
Thank You
:-)