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"
Folk:
My problem is this.
I have installed MSDE 1 (SQL 7 VERSION) in one Win95 Computer.
For some especial reasons y changed the computer name ,and the
MSSQLServer Service refuse startup.
Can you help me?
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.
How can I check to be sure that the MSDE is installed properly and that it is running?
Should I be able to see the Service Manger in the tray?
Thank you,
I have a large VB 6.0 application running with Jet 4.0 Access DB. I am considering moving the DB to MSDE. For testing, I installed MSDE on another computer in a peer to peer network running XP sp1, loaded up the DB from Access to MSDE2000A -- all without problem. (I should add the obvious fact I am new to using SQL server.)
What I find is that with a relatively small test DB, running just a single instance of the application, query response from MSDE is taking several seconds (4-5 second lag) longer than response from the Access DB, which runs extremely fast. This is with the Access DB installed on the same network drive, running the same application and the same queries syntax -- only changing configuration of connection for each (SQL vs Jet 4).
Any clues as to what may be going on? The lag time is unacceptable. I am using SQL password instead of NT security. It seems the process is perhaps lagging in the process of authorization.
Thanks for any suggestions or ideas on this.
Without the Client Network Utility that is available in the full blown MSSQL Server is there a way to find out what port the MSDE is running on?Short and sweet, thats all I needTIA
View 1 Replies View RelatedI have installed WebMatrix and MSDE and have been able to successfully make a connection from WebMatrix to MSDE. I am used to using SQL Server with Enterprise Manager but I do not have that available to me right now so I'm using MSDE instead. I followed the setup instructions on the WebMatrix tutorial and setup MSDE with an SA password. I would now like to change the password to something else. Is there a command that I can use to do that? There is no Enterprise Manager so I'm kind of stumped. Thanks in advance for your help.
Kathleen
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
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?
Currently I am running MSDE on a webserver. The MSDE was installed by a software package for web survey's. I am wondering if SQL express will interfere with this installation? Would I be better to install MySQL instead?
The problem I am trying to solve is simply giving a web developer some database space so that he can connect his web app to store some data. I'm kind of a n00b at this so I thought SQL express would be the best route. If I'm headed in the wrong direction can someone point me the right way?
Cheers!
Hello,
I have one program using MSDE as database. It runs OK on the machine with MSDE or without MSDE.
But it can not connect to MSDE database if PC with 'Microsoft SQL Server 2005' and 'Microsoft SQL Server Desktio Engine(MICROSOFTSMLBIZ)' installed.
Form SQL Server Server Manager: my instance ...MYINSTANCE and ...SQLEXPRESS are both running OK.
Why not connect to my MSDE instance under this situation? Could anyone give me any advice?
Thanks,
Dennis
I want to view the sample databases within Access 2003. When I try to view them an error message appears saying I need MSDE 2000 but this will not run on Windows Vista which is my operating system. What do I need to view the sample database as well as develop applications within Access using SQL server?
View 1 Replies View Relatedi am working on upgrading the clients and server computers from 2000 MSDE to 2005 SQL Express Adv. Plan to upgrade using the template.ini.
i can find the version of sql server running on th server by @@version but how do i find the version of client connctivity components the computer has installed in order to ugrade?
1. somehow i need to know whether to upgrade a client computer CONNECTIVITY COMPONENTS from 2000 to 2005?
2. is there a way to enable tcp/ip in installation script of SQL Express?
THANKS
I have to change machine name for one of SQL Server 2005 machines. Do I need to do anything on SQL Server as well?
Canada DBA
Hello All,
I'm developing pocket PC application.. when I want to replicate my data from pocket pc to development pc.. I've got this error on my pocket pc.. "An error has occurred on the computer running IIS"
Any ideas? Any help?
I'm using SQl Server 2000, SQL Server CE 2.0, VS.Net 2003
Thanks
Im getting this error when I try to synchronize my mobile client with SQL Server Compact 3.5 with my SQL Server 2005 database: "Authentication failed at the computer running iis"
Im debugging through a WM5-device in Device Manager 3.0. I have verified that Internet Explorer on the device manager can reach the synchronization agent. But the same credentials that I use there won´t work in my application.
Im using this code for the synchronization.
Dim repl As SqlCeReplication = New SqlCeReplication()
Try
repl.InternetUrl = "http://192.168.0.115/Sync/sqlcesa35.dll"
repl.InternetLogin = _txtUser.Text
repl.InternetPassword = _txtUser.Text
repl.Publisher = "Name"
repl.PublisherDatabase = "Mydatabase"
repl.PublisherLogin = _txtUser.Text
repl.PublisherPassword = _txtUser.Text
repl.Publication = "My Publicationl"
repl.Subscriber = "MySubscriber"
repl.SubscriberConnectionString = "Data Source=" + (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase)) + "DataAppDatabase.sdf;" 'Persist Security Info=False"
repl.AddSubscription(AddOption.ExistingDatabase)
repl.Synchronize()
MessageBox.Show("Sync completed")
Catch SQLEx As SqlCeException
End Try
Hi, i was following the tutorial in SQL Mobile Books online "Creating a Mobile Application with SQL Server Mobile ", but when i try to run the application using the pocket PC 2003 emulator, the got the following error, "An error has occurred on the computer running IIS, Try restarting the IIS server.", any idea why?
View 13 Replies View RelatedHi Friends,
I am currently trying to develop a small Windows Mobile Application with SQL server Mobile edition.
To develop this , I followed this link http://msdn2.microsoft.com/en-us/library/aa454892.aspx
As I dint find Vendors.sdf database I created My own Database with student table. My database name is MyDB. I created both Mobile database (.sdf) and the same database in sql server 2005
when I run the application I can update the database upto the mobile with no problem. But when I try to Sync I am facing the following exception at the following code.
private void SyncVendors()
{
if (File.Exists(this.DataFileName))
{
this.SaveData();
_repl.Synchronize(); //exception is raised at this line
this.GetData();
}
else
MessageBox.Show("The subscription database has not yet been created. You must first select the Init Sync menu item.");
}
For the replication I used
private void InitReplication()
{
_repl.InternetUrl = @"http://XXXXXXXX/MyDB/sqlcesa30.dll";\ for security reasons I am not using my system name
_repl.Publisher = @"XXXXXXXXX";
_repl.PublisherDatabase = @"MyDB";
_repl.PublisherSecurityMode = SecurityType.NTAuthentication;
_repl.Publication = @"MyDB";
_repl.Subscriber = @"MyDB";
_repl.SubscriberConnectionString = this.DataSourceConnectionString;
_repl.LoginTimeout = 120;
//_repl.InternetLogin = "XXXXXXXXXXXXXXXXXXXX€?; //Timely I used these 2
//_repl.InternetPassword = "XXXXXX€?;
}
"An unhandled exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in System.Data.SqlServerCe.dll
Additional information: Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect."
Or (Some times when I change the Directory Security in IIS)
An unhandled exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in System.Data.SqlServerCe.dll
Additional information: Authentication failed on the computer running IIS
I tried in many ways like
Ø Resetting the firewalls ( to web server(http))
Ø In sql server I set " using both TCT/IP and named pipes
Ø In IIS virtual directory--> directory security à settings I used anonymous, base authentication, integrated Authentication. The same exception with any authentication.
Ø SQL Server Management studio à view à Registered Server Types à SQL Server Mobile. Here I added my data base MyDB.sdf.
Ø SQL Server CE Connectivity Management à selected my database à and select authentications
this is my log in virtual directory
2008/01/28 14:37:11 Hr=80004005 ERROR OpenDB failed getting pub version 28627
2008/01/28 17:05:08 Hr=80004005 ERROR OpenDB failed getting pub version 28627
2008/01/28 17:12:16 Hr=80004005 ERROR OpenDB failed getting pub version 28627
2008/01/28 17:33:35 Hr=80004005 ERROR OpenDB failed getting pub version 28627
can any one please help me?
Thanks in Advance.
Does anyone know whether or not both versions can be installed on the same machine?
View 1 Replies View RelatedI am about designing an access project file that connect to a SQL Server database : it could be either on the local computer or a remote workstation, this depending on where the front end is running.
Bypassing the default log on dialog box i have set my own form that users should use to connect on adp. Then using baseconnection string i connect the adp to sql server database.
My concern is how can i check from vba if the instance of SQL Server where my back end database is located is running in order to make
users knowing that due sql server service status off their connection
tentative will fail.
inform u i can check same from console management however i would to automate same controle from my adp and avoid that users have to operate such task...
Hi All,
I recently was required to change the name of my machine, where SQL Server 2005 (Enterprise) was installed. I then tried to open a pre-change database, and SQL Configuration Manager gave me an error saying it "...could not obtain information about Windows NT/user..." Upon further digging, the Properties->Permissions of that particular database is tied to the old computer name. Eveything else seems to have updated to the new name, and I can't seem to figure out a way to change the old reference.
Help!
kinso
Hello,
I am trying to complete the BOL sample "Creating a Mobile Application with SQL Server Mobile". Using SQL 2k5 and VS Team Suite. I have the emulator about to get on to the internet and can even get to the http://sqlce.domain.com/sqlmobile/sqlcesa30.dll url but when runing the vb.net code I get the error 28037 "A request to send data to the computer running IIS has failed. For more information, see HRESULT.". Any help would be greatly appreciated. No software firewalls are running. I have a dns entry that points to my laptop for testing. The sync function code is below.
Sub sync()
Dim repl As New SqlCeReplication()
repl.InternetUrl = "http://sqlce.domain.com/SQLMobile/sqlcesa30.dll"
repl.Publisher = "MY-LAPTOPDBSERVER"
repl.PublisherDatabase = "SQLMobile"
repl.PublisherSecurityMode = SecurityType.NTAuthentication
repl.Publication = "SQLMobile"
repl.Subscriber = "SQLMobile"
repl.SubscriberConnectionString = "Data Source='" + filename + "';Max Database Size=128;Default Lock Escalation =100;"
Try
repl.AddSubscription(AddOption.CreateDatabase)
repl.Synchronize()
Catch err As SqlCeException
MessageBox.Show(err.ToString)
End Try
End Sub
http://sqlce.domain.com/sqlmobile/sqlcesa30.dll?diag
SQL Server Mobile Server Agent Diagnostics
2006/04/04 15:28:51
General Information
Item
Value
Server Name
sqlce.domain.com
URL
/SQLMobile/sqlcesa30.dll
Authentication Type
Anonymous
Server Port
80
HTTPS
off
Server Software
Microsoft-IIS/5.1
Replication
Allowed
RDA
Allowed
Logging Level
1
Impersonation and Access Tests
Action
Status
ErrorCode
Impersonate User
SUCCESS
0x0
ReadWriteDeleteMessageFile
SUCCESS
0x0
SQL Server Mobile Modules Test
Module
Status
ErrorCode
Version
SQLCERP30.DLL
SUCCESS
0x0
3.0.5207.0
SQLCESA30.DLL
SUCCESS
0x0
3.0.5207.0
Reconciler Test
Reconciler
Status
ErrorCode
9.0 Database Reconciler
SUCCESS
0x0
8.0 Database Reconciler
SUCCESS
0x0
SQL Server Module Versions
Module
Version
sqloledb.dll
2000.85.1117.0
9.0 replrec.dll
2005.90.1399.0
9.0 replprov.dll
2005.90.1399.0
9.0 msgprox.dll
2005.90.1399.0
8.0 replrec.dll
2000.80.2039.0
8.0 replprov.dll
2000.80.2039.0
8.0 msgprox.dll
2000.80.2039.0
We have developed a Winmobile 5.0 application using VS2005 and Sql 2005 CE. We have successfuly installed the Server Agent on the web server and using the url 'http://websitename/rdatest/sqlcesa30.dll' have received an acknowledgement from the server agent. When we set up the Web Syncronization Wizard we kept things simple and opted for anonymous access. However, our Sql 2005 is based on a separate dedicated server which can be accessed by the web server. Our website, also written in VS2005, uses the following connection string to access the Sql 2005 database for our website.
"server=172.18.22.222; database=Audit; uid=steve; pwd=letmein"
When using the following code in our PDA application we have tried the above string as well as another interpretation with the same resulting error 'A request to send data to the computer running IIS has failed, for more information please see HResult'. The code we are using is..
Using rda As New SqlCeRemoteDataAccess()
Dim sCon As String = "Provider=SQLOLEDB;Data Source=172.18.22.222; Initial Catalog=Audit ; UserID=steve; Password=letmein"
Dim sCon As String = "server=172.18.22.222; database=Audit; uid=steve; pwd=letmein"
rda.InternetUrl = "http://websitename/rdatest/sqlcesa30.dll"
rda.LocalConnectionString = "Data Source=Program FilesTestSysTestdata.sdf"
Try
rda.Pull("Detail", "SELECT Details, Actions FROM Detail", sCon, RdaTrackOption.TrackingOff, "DtlErrors")
Catch sqlCeEx As SqlCeException
RecError( sqlCeEx.ToString)
End Try
End Using
Having tried both connection strings we feel the error is caused by something else possibly on our dedicated Sql server. Would really appreciate any help.
Hi,
I Have an application for Pocket PC 2003 developed in Visual Studio 2003(VB.Net , Smart Device App). I Use Sql Server CE as the database which Synchronizes with Sql Server 2000, SP4. The IIS and the Sql Server 2000 are in different Machines. I Have Installed the proper Sqlserver Ce in the IIS machine and created virtual directory with Basic authentication.I connect my device through Active Sync 3.7. I could browse the sscesa20.dll from Pocket IE and get the ' SQL Server CE Server Agent ' message. The PC to which my pocket PC is connected is under a Proxy.
When I tried the RDA.Pull() , the function fails and returns the error
" Error Code: 80072EE7
A request to send data to the computer running IIS has failed. For more information see HRESULT. [,,,,,]
Minor Error : 28037
Source: Sql Server 2000 Windows CE Edition. "
The same application works in other network which is not under a proxy.
Any clues ?
Thanks,
Jibu
eSystem Software
Hello,
When I try to access a SQL Server report on the localhost that I have deployed, I get a message that "under default settings SQL Server does not allow remote connections." After doing a little bit of searching, I went to the SQL Server Surface Area Connection and changed the server instance to allow for local and remote connections of both TCP/IP and named pipes. I stopped and restarted the service. Even after doing this I still get the same error.
If the Surface Area Configuration can't help out in this situation, what else would need to be modified?
Thanks,
CCG
How can I identify the computer of the person running an SRS report? If I query HOST_NAME() it gives me the host of the reporting server, not the person browsing.So, for example, Melissa opens a browser from computer named AAA to the SRS and pulls up her report. How do I get that report to show that the user is browsing from AAA?
View 12 Replies View RelatedHi guys,
View 4 Replies View RelatedHi,
My application is working under InternetUrl "http://servername/test/sqlcesa30.dll", but I am getting following error for "https://servername/test/sqlcesa30.dll"
"A request to send data to the computer running IIS has failed. For more information, see HRESULT."
We have proxy server top of the web server and certificate is installed on proxy server. There is no ceritificate installed on web server which is behind the firewall. Proxy server divert the request on different protocol based on "http" and "https" request and send to web server which is behind the firewall. I am not getting any error when i use RDA using http for above environment, but when i use RDA using https I am getting an above error for the same environment.
Can anyone help me to resolve this issue?
Thanks in advance
I looking for some guidance here. I have database which has exceeded the 2 gig limit. I deleted some old tables in an attempt to acquire some space. This worked out. However when I look at the size of my *.mdf it still appears in excess of the 2 gigs . I know this isn't true since I deleted 500 megs of stuff. How do i reclaim the space (get the file size to report correctly) or do I need to even worry about it.
Andy
Hi
I have visual studio .net and i recently installed MSDE specific for visual studio.
The name of my server is FRANKNETSDK.
String strConnection ="server=FRANK\NETSDK;database=Northwind;integrated security=true";
SqlConnection objConnection = new SqlConnection(strConnection);
objConnection.Open();
objConnection.Close();
I created an instance which is NETSDK
I created a password
I don't know why my server choose the name FRANK i was expecting local.
I have to use FRANKNETSDK or else i can't get my server to Start.
This is the error: Login failed for user 'FRANKASPNET'.
[SqlException: Login failed for user 'FRANKASPNET'.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
sqlconnect.WebForm1.Page_Load(Object sender, EventArgs e) in c:inetpubwwwrootsqlconnectwebform1.aspx.cs:27
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
Any help would greatly be appreciated.
Hi
For quite some time nowI have been trying to give user rights to my MSDE , needless to say the fruits of my labor have turned up very little success.
So far i have tried using the osql commands to grant user access to my database. I have run the stored procedures(sp_grantlogin ,sp_grantdbaccess ) but to little avail!
So now i have taken a new approach i installed the Enterprise Manager. I have just a minor problem with this new strategy , i don't know how to use it!!
This is what i have prensently installed on my system: Visual studio.Net ,Microsoft SQL(MSDE)
and finally the Enterprise Manager.
My Servername is FRANK.
I have created an instance which is NetSDK (FRANKNETSDK)
My SAPWD is Kildare
I have Mixed Mode
Can anyone please tell me how i can use the Enterprise Manager to grant access to MSDE.
I am sure you have all realized from all these insipid post that i have no experience.
So please be explicit in all your details.
My email roti@videotron.ca
Thank you
Frank
Having Problem connecting to Database with WebMatrix
When I try to ADD Database in WebMatrix through Sql Connection & enter USERNAME & PASSWORD it fails. Is there a way to create New USERNAME & PASSWORD? Perhaps through
the Command Line Prompt?
Any Help/Advice TIA
Tristen
I have never done anything with databases, so I am a newbie. My goal is to install an ASP.NET forum, but I need MSDE installed. I downloaded MSDE from the Microsoft website. When I run the setup.exe file, I get an error. It says:
A strong SA password is required for security reasons. Please use SAPWD switch to supply
same. Refer to readme for more details. Setup will now exit.
I looked at the documentation but could not find anything usefull, what do I have to do to install it. Thanks in advance for responses.