How To Set A Job To Run On A Remote MSDE Server?
Apr 12, 2004
3 of 100 MSDE servers' sql agent stop working with 'sqlAgent servise has marked as deleted'.
1. is there a way to fix this service could not start issue?
2. probably not. before moving all DBs to a new MSDE server, I run scripts on daily via isql to these 3 MSDE to run the daily backup and dbcc jobs. The problem is I could forget to run.
I tried to run following:
backup database remote1.db1 to Backup_db1 with init
so that I could run a job from my server on scheduling time. but it did not work.
Any idea to turn manual process to semi-weapon?
thanks
-D
View 1 Replies
ADVERTISEMENT
Nov 24, 2003
I installed MSDE at my server at home, and that works fine.
On the server I can access my MSDE perfectly.
But, from a remote computer it seems impossible to connect.
Some (maybe) important information:
To create a user at my msde I used:
sp_addlogin (@ the MASTER DB)
sp_adduser (@ My DB)
sp_addrolemember (@ My DB)
Then I runned SVRNETCN.exe and enabled TCP/IP.
btw: I don't have a firewall running and both computers are on the same local network.
View 8 Replies
View Related
Jun 26, 2004
For a SQL Server 2000 connection string I usualy use the following format:
server=somewhere.com;uid=sa;password=sa;database=myDB
or:
server=66.33.11.123;uid=sa;password=sa;database=myDB
However, now I am dealing with a remote MSDE database. What is the format to connect to a remote MSDE database? Is it:
server=<IPADDRESS><INSTANCENAME>;uid=sa;password=sa;database=myDB
Where <IPADDRESS> is the Ip address of the remote machine and <INSTANCENAME> is the MSDE instance name. Is this correct? If not, what am I doing wrong?
View 4 Replies
View Related
Oct 24, 2006
Hi all,
I have 2 pcs connected each other and one has the MSDE installed, i would like to access PC1 MSDE instance remotly is this possible or MSDE couldn't be used in network environment and just locally?
TIA
Tiago Teixeira
View 6 Replies
View Related
May 1, 2007
Hi all,
I installed a MSDE on a Windows XP SP2 and configured it for accepting remote connections. But It shows the "SQL Server doesnot exist or connection denied" message whenever I try to connect to this server. For more information I am adding more facts
* It is an MSDE and not a WMSDE
* Firewall is turned off
* Server process is listening on 0.0.0.0:1433
* TCP/IP and Named Pipes are enabled using server network utility
* LoginMode=2 is set for mixed mode authentication in the registry
* Tried restaring the Process and even windows after the changes.
Please help me !!
Thanks in advance
View 1 Replies
View Related
Dec 5, 2004
My question is, is it possible to connect to an SQL database using the MSDE 2000 SP3a edition over the internet? And if so, how do I set it up? Thank you in advance.
View 1 Replies
View Related
Jan 25, 2006
I'm trying to connect to the SharePoint MSDE database from Windows XP
SP2 machine over Ethernet LAN. I was getting server not found or access
denied, until I enabled TCP/IP via svrnetcn.exe. Now, I'm getting
OK
Connection failed:
SQLState: '01000'
SQL Server Error: 10061
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen
(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not
exist or access denied.
I just did an netstat -an and I don't see the server listening on 1433.
What am I not doing?
The svrnetcn tool has no effect. I make a change and check the logs,
but nothing happens. What would be causing this?
View 4 Replies
View Related
Sep 22, 2007
We just installed an application, WhatsUpGold, to monitor our servers. Management won't let me host that on my primary SQL box. So, we are using MSDE on the local machine (call that box my_netmon).
I can access the db with very basic functionality using osql while on the my_netmon machine. I've added my domain user account as a System Admin using the following commands.
exec sp_grantlogin @name
go
exec sp_addsrvrolemember @name, 'sysadmin'
But when I go to the my_sql machine and try to attach to it with Enterprise Manager I get an error that the server does not exist.
What gives??? Is it just not possible, or am I missing something here?
My goal is to just be able to see the data stored in the MSDE db. Write views, etc...
Please advise,
Marc
View 2 Replies
View Related
Jun 2, 2015
- When I disable "allow remote connections to this server" from server properties>connection page, I can still remotely connect to the server from SSMS...so what is the impact of enable/disabling it?
- what is the impact of changing the remote query timeout (on the same page) from default value?
View 4 Replies
View Related
Nov 10, 2006
I am trying to add a linked server from a AMD x64 server (Windows 2003) with SQL Server 2005 64 bit to a Server running SQL 2000. These are not in the same domain.
I can create a linked server using the option "Be made using the login's current security context" but can not when trying to specify the security context, i.e. sa and the sa password. When I try I get the following message:
Msg 15185, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 98
There is no remote user 'sa' mapped to local user '(null)' from the remote server 'DTS_FSERVER'.
I have several other x64 server that I have no problem creating a linked server and specifying sa and the sa password.
The problem with using "the login's current security context" option is that I get an error when trying to run any Jobs against the linked server. The job fails withe the following error:
Executed as user: NT AUTHORITYSYSTEM. Access to the remote server is denied because no login-mapping exists. [SQLSTATE 42000] (Error 7416). The step failed.
I'm sure the two errors are related. Any ideas what is going on?
View 7 Replies
View Related
Jun 6, 2005
Hello,
I'm not sure if it's the setup I did wrong, but I can't seem to get my
text datatype in my database to store more than 900 characters.
I'm trying to setup a news database for my website, which will populate
the information into a datagrid. To test, I manually added a news
item in the database through the visual studio 2003 gui. I
immediately noticed a problem as the I was getting an error after a
long news item saying:
"The value you entered is not consistent with the data type or length of the column, or over grid buffer limit."
I couldn't find anthing to set the buffer limit and the datatype is
"text" filled with simple text in the column. As a further test,
I
simply entered 12334567890123... up to 900 characters and still
recevied the error.
I would appreciate someone leading me in the right direction on this one.
Thanks a lot.
View 1 Replies
View Related
May 27, 2000
I am trying to change the computer name of a machine running MSDE but I get an error when SQL Server starts. With regular SQL when I change the name of a computer I re-run setup and setup fixes this problem. MSDE can only be installed from unattended mode so I can’t rerun setup and fix the problem.
My question is "How do I change the name of a computer running MSDE with out reinstalling MSDE"
View 1 Replies
View Related
Mar 27, 2001
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
View 3 Replies
View Related
Mar 9, 2005
I'm not sure if this is the correct forum for this this question but I'll give it a shot.
The only db development that I have ever done is in MS Access. I have a project at work that is being accomplished in VB and I need a db engine to use as the back end. Visual studio came with a copy of MSDE. Is this tool worth using or should I invest in mySQL? Are there any advantages to using MSDE over mySQL?
View 4 Replies
View Related
Aug 6, 2007
Hello,
at the moment I have the following problem:
We have installed a version of the MSDE 2000 Sp3 with our software since 2005. Now we install SQL Server Express 2005 in order to use the latest version and to be compatible with Vista.
We have never had any problems with the MSDE, so it was no problem that we installed the german version (by mistake) because there never was any output at installation time.
When we now upgrade the existing MSDE installing the new version of our software, there are often problems and there are error messages, unfortunately in german, which cannot be read by most of our international users.
The problem is, that there seems to be no possibility to upgrade the existing (german) MSDE with the english version of SQL Server Express 2005.
My question is, if it is possible to upgrade the german MSDE to the english SQL Server 2005 to enable our international users to read the error messages at installation time in english?
Thanks in advance.
Best regards,
Peter
View 4 Replies
View Related
Jan 24, 2006
After installing MSDE(with SP4) and SQL Server 2000 SP4 Replication Components, the SQL Server 2005 Mobile Server Tools installation fails when running the System Configuration Check with a SQL Server requirement Error.
"You must first install the Replication Components for SQL Server 2000 SP 3a or higher or the SQL Server 2005 Replication Components"
Am I getting this error because I'm using the Desktop Engine version of the SQL Server 2000??
View 7 Replies
View Related
Jan 26, 2004
Apparently since I downloaded SQL Server SP3 and tried to install it on a computer without SQL Server in the first place, it's a bad thing.
I'm trying to get SQL Server Desktop Engine to install and I do the cmd.exe thing and it works, then 1 second before it finishes it rolls back.
All the files are still there, just missing the ones you need to run the SQL Server.
I used to have it on my 98, before I upgraded. Now I have the ASP.NET WebMatrix on my XP Home.
Is there a way to get SQL to install correctly?
John
View 2 Replies
View Related
Jul 23, 2004
I have created a SQL server database on my localhost. The live server that I am going to host the site does not have SQl server. I was thinking of putting MSDE on the live server. Would I have to make any changes to my SQL server database to put on the live server where i only have MSDE. Any idea what's involved with all that??
Thanks!
View 2 Replies
View Related
Dec 14, 2004
I have an SQL Server .MDF and .LDF file. The files were created a while ago and backed up. Well I need to use the database again, however I can't use SQL Server. So my next solution is MSDE.
How to I create a new database in MSDE using the already created .MDF and .LDF files as the actual database?
View 1 Replies
View Related
Dec 22, 2004
Hi have just installed MSDE on a laptop. When I installed it I created a default account
username - sa
password - ?
With network protocols enabled and in mixed mode.
I then Created a script of a databse from are SQL server and ran that on the MSDE. So now I have an identical database on the laptop, but without any data. All going well hey.
The problem is I am now trying to copy the data across using the DTS wizard in SQL server. I can select the server from the dropdown, but it will not let me connet, it says not aurthorised or cannot find server. I am using SQL authentication, and using the user account sa. Any ideas what I'm missing. Am very new to SQL server, so any help would be very much appreciated.
View 7 Replies
View Related
Jan 15, 2004
I own a copy of SQL Server 7 but am not using it for anything at present. I want to convert an Access db to this Server however I'd like to have a development environment on my laptop. Can I install MSDE and manually transfer the .db files to and from the SQL Server seamlessly?
Thanks
Dog
View 2 Replies
View Related
Jan 29, 2004
I am using SQL Server 2000 MSDE for Test Development of a site in .Net. The MSDE is installed on my workstation and the web site is depolyes on a web server. When I try to access data from the site at the development server, the connection to the SQL Server MSDE fails, saying:
System.Data.SqlClient.SqlException: SQL Server does not exist or access denied
But when I access the web site from the same box where the SQL Server MSDE is installed, everything works fine.
Here is the connection string I am using:
<add key="DBConnection" value="Data Source=<MyMSDEBoxName>; Initial Catalog=<DatabaseName>; Integrated Security=SSPI;"/>
I have tried using User Id and Passoword but it failed too!
Any help will be appreciated.
View 2 Replies
View Related
Feb 4, 2004
Hi,
We have developed a product in VB using MS-Sql Server200 as the DB. Now for distributing the product we have decided to use MSDE. Can any one tell me how to distribute the Product with MSDE. What should we do for that
Thanks in Advance
View 1 Replies
View Related
Jun 21, 2005
hi - I am developing locally using .Net 2.0/Access but just recently started trying out SQL Server Express. I have deployed my application to a host who provides 2.0 but as would be expected only MSDE/SQL server 2000. Now if I'd switch completely to SSE, would my SQL queries (which are pretty simple) work on MSDE or SQL server 2000? The only thing I see as more sophisticated sql queries would be the built-in 2.0 Roles/Membership functions... Do you think they would run smoothly on MSDE/SQL 2000?Finally... since the database is already done locally, is there any way (a stored procedure for example) to copy it's scheme if I'd create a new DB on my host's SQL server?
View 2 Replies
View Related
Oct 26, 2006
We have 3 MSDE databases (3 seperate servers) which we need to make into one Sql 2000 server (new server). How is this done? Can't find anything clear about this.
Thanks
View 3 Replies
View Related
Aug 23, 2006
Fellow Devs,
I have an instance of SQL Server Express 2005 running on another box and I have Remote Connections enabled over both TCP/IP and Named Pipes, but on my other box I keep getting the error that the server does not accept Remote Connections.
Any ideas why this might be happening? Is there some other configuration?
View 25 Replies
View Related
Jan 4, 2013
if you can restore a database to Server B using Server A as the service. Meaning we would issue the command on Server A but somehow point to Server B as where we want the restore to happen.
The backup file would be in a location independent of both servers.
View 4 Replies
View Related
Jan 22, 2008
My site works fine in VWD2008 express, but I get this error when I try to use it on my live website.
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.
According to this article: http://support.microsoft.com/kb/914277 I am supposed to:
1.
Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration.
Ok, there is no such program in this folder. The only thing in there is "SQL Server Error and Usage Reporting"...
The other thing I am greatly concerned with is this: All is want is for my webpages to be able to access my database for user authentication. I DO NOT want to grant the internet rights to remote connect to my database.
View 4 Replies
View Related
Dec 9, 2003
Hi
I think I must operate a similar system to the rest of you here, where I have a Shared SQL Server Database on the web for my website and since I cant afford the full SQL Server to develop on I'm developing on the MSDE that comes with VS.net(I think thats where I got it longtime ago). Anyway my point is since in the database project on VS.net I cant generate Create Table SQL Code against MSDE, Apparently you need the full SQL Server to do that. Whats the best way for me to transfer any changes from my dummy development database to my production database on a real SQL Server.
Any help would be appreciated I'm still rather new to SQL Server(been using cheap MySQL) so could do with some pointers.
Thanks
Andy
View 2 Replies
View Related
May 30, 2004
I plan on replacing a SQL2000 database with MSDE for lowering budget.
Can we script up the SQL database (with SPs, triggers, and UDFs) and recreate it in MSDE?
Thanks.
View 3 Replies
View Related
Jul 29, 2004
I have installed MSDE on Windows Server 2003 along with IIS. I am having problems getting SQL SM to work. I cannot login to it.
Here's how I installed SQL SM:
setup.exe /qb+ INSTANCENAME=NetSDK DISABLENETWORKPROTOCOLS=1 SAPWD=paswd
I cannot log in...
I have tried Windows Integrated and SQL login...
View 2 Replies
View Related
Mar 11, 2005
Is it possible to link MSDE to another server through ODBC? I want to do this like you can in Access, where you get external data by linking tables. Any ideas? Thanks!
View 1 Replies
View Related
Apr 20, 2005
Hi All,
I recently created my entire site before even starting to look at hosting providers. It's a very complex ASP.NET e-Commerce site built on SQL Server. I've (nearly) got it to a point where I want it to go live.
I found a host that caters for all my needs and is a good price. What I need to do now is migrate all my data, as well as all my tables and stored procedures, into the database with my host.
Is there an easy wy to go about this?
- Mina
View 2 Replies
View Related
