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
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.
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?
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?
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.
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.
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...
- 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?
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?
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.
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"
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 ??
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?
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?
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??
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??
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?
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.
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?
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.
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
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?
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.
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?
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.
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.
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.
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.
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!
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
