sadegh writes "hello
i installed sql server 2005 on my windows xp sp2 os for the first time. but it doesent recegnize any servers and also,no server is listed in registered servers and object explorer.
and also in connect to server dialog box,when i click on browse for more... , it cannot find any local o network servers. ( this is my personal pc and not connected to any networks.)
how can i define a server for the first time?
thank you"
HiWhen I attempt to install MS SQL Server evaluation copy (downloadedfrom Microsoft site) on Windows 2K Professional getting followingerror.Setup initialization error.The system cannot find the path specified.Source file or directory missing or cannot be read:'C:SQLEVALx86setup..Systemsqlunirl.dll'Please help.Regards,AG
I just downloaded the SQL SERVER 2005 TRIAL EDITION. Where to I get the SQL Server Management Studio from? Can I use SQL Server Management Studio Express?
Does anyone know where I might find this CAB file? Where do I put so the installation can find it?
MSI (s) (58:F0) [16:59:30:375]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI56F.tmp, Entrypoint: StartCache Action start 16:59:30: StartCache. StartCache: Error 0x80070490: failed to get cabinet: PA655502.CAB StartCache: Error 0x80070490: failed to set state for cabinet: PA655502.CAB
I originally posted my problem on 01/19/2007, look for that post if you'd like to see the complete log files.
Is it possible to install and configure the MSDTC resource in a SQL Server 2000 cluster after SQL is installed and running?
When I recently went through a rebuild of my cluster, I forgot to install the resource before installing SQL Server. Now, if I install and bring online the MSDTC resource the SQL disk groups will not fail over correctly. The SQL Server resource will not come online.
Thanks in advance for any help. I would really like to avoid rebuilding again.
We have an application server running Windows Server 2000 with Sp4. When we use the ODBC data sources connection software, it shows the SQL Server 2000 servers in the drop down box, but none of the new 2005 servers. If we enter the 2005 server name and try to connect, we get the 'Specified SQL Server not found' error message. The connection works fine from a newer Windows XP box and remote connections is enabled. My guess is that we need a new ODBC to connect to SQL Server 2005, but I can't find anything that says this.
Is it possible to install SQL Server 2005 Eval on a Virtual PC 2007 client running Server 2008 Beta? Nothing says it isn't possible, it says I need to service pack it right away, but before it gets started it comes up with the error 'sqlcu.dll failed to load'. Anyone know what this is all about?
If SQL Server Setup fails, Setup will roll back the installation but may not remove all .manifest files. The workaround is to rename the files and then rerun Setup. For more information, see How to: Work Around COM+ Check Failure in SQL Server Setup.
We've devoted a resource to this today, but I have to believe it's something easy that we're overlooking. The scneario is that we have a production Web application that until last weekend had a SQL 2000 back end. This weekend we installed a new instance of SQL 2005 and everything works (we tested in a sandbox environment, but someone must not have load tested enough) and never saw these exceptions. So, after the upgrade we now receive 100's of thexe SQL excptions per day:A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)Does anyone know what we've overlooked that's causing this issue?Thanks for any help!
I have tried several times to install SQL server onto an NT4.0 server which is more than capable of having more than one application to cope with, however, when going through the install procedure the programm stops with the following message
DR.Watson Access Violation Setup.exe In address :
Any hints as to where the problems lies or point me inthe right direction would be appreciated.
I'm trying to install SQL Server 2005 on a server 2000 machine, everything is working with the exception of the Web Service Identity. It is putting machinenameASPNET, and I don't know where to go to make it use something else. I've look around but I have really seen any answers that have worked for me.
I just installed Windows Server 2008. The installation also included Web Server.
When I tried to install SQL Server, I got the following warning:
IIS Feature Requirement (Warning)
Messag
IIS Feature Requirement
Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.
Can somebody advise me on how I can resolve this warning? Would running SP2 take care of this?
Recently I have installed Visual Studion Team System 2008 Development Edition in my sytem. Along with this, MS-SQL Server aand MSSQL Server Compact Edition is also installed. I need to install the SQL Server 2005 in my system.
In such a scenario, does the Compact Edition is required? Can I uninstall them and install Sql Server 2005 only? If I uninstall anything, would it cause any problems for the .Net programs to work?
Hi all, Im new here so il start with a little introduction of myself, My name is Arjan im 19 years old from Holland, and i work for a company to compleet my ICT Education.
My situation:
My boss gave me a server with server 2003 standard and Sql server 2005 and visual studio 2005 installed already, he asked me if i could figure out how the 'new' reporting services work, Im pretty new to SQL and the reporting service but i figured out i had to install asp.net / frameworks and IIS.
So right now i wanna start the Reporting Services Configuration Manager and i get an error that says 'Invalid namespace' and when im trying to approach by using my browser i get 'page not found' so obviously their is Alot wrong. I asked my boss if i could not reinstall everything and do it in the correct order (IIS / ASP.net / Frameworks before installing SQL server 2k5 but that was not an option because we dont seem to have the cd's anymore.
The server is not connected to any network or the internet.
My Question:
Is their any way to fix this? and if yes could anyone tell me where to start
Thanks in Advance!
ps if their is information or logs that u need in order to help me just say so :-)
I have inhereted this application and I am a newbee at asp.net. Fisrt my apologies for posting such a large amount, I just wanted to give you all the information that I possibly can.
I have the follwoing error "Specified SQL server not found".
Server Error in '/ppasa' Application. --------------------------------------------------------------------------------
[Microsoft][ODBC SQL Server Driver][DBMSLPCN]Specified SQL server not found. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Runtime.InteropServices.COMException: [Microsoft][ODBC SQL Server Driver][DBMSLPCN]Specified SQL server not found.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[COMException (0x80004005): [Microsoft][ODBC SQL Server Driver][DBMSLPCN]Specified SQL server not found.] ADODB.ConnectionClass.Open(String ConnectionString, String UserID, String Password, Int32 Options) +0 PPASA.PPASA.OpenCloseDB(Boolean Connect) in c:inetpubwwwrootPPASAPPASA.vb:9 PPASA.Login.btnSubmit_Click(Object sender, EventArgs e) in c:inetpubwwwrootPPASALogin.aspx.vb:38 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain() +1277
-------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
The process of my application works as follows. 1)Login.aspx submits the username and password. It is linked to Login.aspx.vb with the following statement <%@ Page Language="vb" AutoEventWireup="false" Codebehind="Login.aspx.vb" Inherits="PPASA.Login"%> 2)In Login.aspx.vb (below) has a call to PPASA.vb with the following statement Call OpenCloseDB(True).
Public Class Login Inherits System.Web.UI.Page
#Region " Web Form Designer Generated Code "
'This call is required by the Web Form Designer. <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
End Sub Protected WithEvents Label1 As System.Web.UI.WebControls.Label Protected WithEvents Image1 As System.Web.UI.WebControls.Image Protected WithEvents Label2 As System.Web.UI.WebControls.Label Protected WithEvents txtUsername As System.Web.UI.WebControls.TextBox Protected WithEvents Label3 As System.Web.UI.WebControls.Label Protected WithEvents txtPassword As System.Web.UI.WebControls.TextBox Protected WithEvents btnSubmit As System.Web.UI.WebControls.Button Protected WithEvents btnClear As System.Web.UI.WebControls.Button
'NOTE: The following placeholder declaration is required by the Web Form Designer. 'Do not delete or move it. Private designerPlaceholderDeclaration As System.Object
Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init 'CODEGEN: This method call is required by the Web Form Designer 'Do not modify it using the code editor. InitializeComponent() End Sub
#End Region
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'Put user code to initialize the page here End Sub
Private Sub btnSubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSubmit.Click Dim rs As ADODB.Recordset
Call OpenCloseDB(True) rs = cnn.Execute("SELECT ID FROM PPASA_User WHERE Name='" & UCase(txtUsername.Text) & "' AND Password='" & txtPassword.Text & "'") If Not rs.BOF And Not rs.EOF Then Call PopulateUserInfo(rs.Fields(0).Value) Server.Transfer("PPASAMain.aspx") Else Call ClearLoginBoxes() End If Call OpenCloseDB(False)
End Sub
Public Sub PopulateUserInfo(ByVal MyID As Integer)
Dim rs As ADODB.Recordset
Call OpenCloseDB(True) rs = cnn.Execute("SELECT ID,Name,Security FROM PPASA_User WHERE ID=" & MyID) If Not rs.BOF And Not rs.EOF Then rs.MoveFirst() 'CurrentUser.ID = rs.Fields(0).Value 'CurrentUser.Name = rs.Fields(1).Value 'CurrentUser.Security = rs.Fields(2).Value Session.Add("ID", rs.Fields(0).Value) Session.Add("Name", rs.Fields(1).Value) Session.Add("Security", rs.Fields(2).Value) Session.Add("DonorID", 0) End If Call OpenCloseDB(False) End Sub
Private Sub ClearLoginBoxes() txtUsername.Text = "" txtPassword.Text = "" End Sub
Private Sub btnClear_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnClear.Click Call ClearLoginBoxes() End Sub End Class
3)PPASA.vb then creates the connection to the Database. PPASA.vb looks like this.
Module PPASA
Public cnn As New ADODB.Connection
Public Sub OpenCloseDB(ByVal Connect As Boolean)
If Connect = True Then If cnn.State = 0 Then cnn.Open("Description=PPASA;DRIVER=SQL Server;SERVER=THE-ONESERVERA;UID=sa;PWD=123;APP=Microsoft Data Access Components;DATABASE=PPASA") End If Else If Connect = False Then If cnn.State = 1 Then cnn.Close() End If End If End Sub
Public Function CheckSecurity(ByVal Actual As Integer, ByVal Required As Integer) As Boolean If Actual >= Required Then CheckSecurity = True Else CheckSecurity = False End If End Function End Module
4)After I submit Login.aspx the application boms and gives me the "Specified SQL server not found".
Extra Info:
The Sql server is up and running. I have tested it by connecting with 2 test connection files index.asp and index2 .aspx. Here are the files. The files also return results from the pubs db.
index.asp
<% Set conn = Server.CreateObject("ADODB.Connection") strConn="DRIVER={SQL Server};SERVER=THE-ONESERVERA;UID=sa;PWD=123;DATABASE=pubs"
conn.open strConn
sql = "SELECT * from authors" set rs = conn.Execute(sql) if not rs.EOF then while not rs.EOF lastname = rs("au_lname") firstname = rs("au_fname") response.write "LASTNAME :: " & lastname & " \// FIRSTNAME :: " & firstname & "<br>" rs.movenext wend end if conn.Close() Set conn = Nothing %>
and index2.aspx
<%@ Page aspcompat=true %> <% Dim objConn Dim strConn Dim objRs Dim objCmd Dim objField
If Not objRs.EOF then Do While Not objRs.EOF response.write ("VALUES :: ") For Each objField In objRs.Fields Response.Write (" " & objField.value & " \// ") Next response.write ("<br>") objRs.movenext Loop End if
objConn.Close() %>
There are also the following files in the bin directory. Interop.ADOR.dll Interop.MSChart20Lib.dll Interop.Scripting.dll PPASA.dll utCharting.dll
So my question is this, why do I get the error "Specified SQL server not found", when I dont get the error with the test connection files.? Do I have to do anything with the .dll file in the bin directory, like register them or something? How does the Login.aspx.vb file call the PPASA.vb file when I see no reference to PPASA.vb in the Login.aspx.vb file? I would appreciate any help or suggestions. Thanks
I have 2 server 2003 boxes one has sql 2000 and the other has IIS. I can pull up my pages on the iis server but as soon as my app tries to access the sql server I get cannot find server. All my settings are correct in the web.config file. I do not have this problem with the same setup on server 2000 boxes. Also active dir is not set up on the 2000 or 2003 boxes. Can someone please help. thanx weisenbr
I am trying to connect to my SQL Server through my ASP.NET webpages. My problem is that, no matter what I do, it always says that the server is not found. I know the IP address of my server, and this IP address works from other computers within my network, just not mine.
I have no idea what it could be. If anyone knows, any help would be greatly appriciated.
Hi, i have just started working with asp.net and purchased a book which has MSDE with it for database access. Ihave followed all the instructions on how to install MSDE, however when i try to set up a database using Miscrosoft ASP.NET Web Matrix, i get the error message:Unable to connect to the database server.SQL server does not exist or access denied.ConnectionOpen(Connect()).This message occurs when i am creating a new database.does anyone have any ideas why this may be happening?I have MySQL installed on my computer, could this be interfering with the MSDE ?Thanks....
Sometimes when I try to connect to an existing server (sql 7.0) , I get the error message "specified sql server not found-check registration properties" and it refuses to connect to it. Has anyone encountered this before? Do help.
and i get "[Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL server not found."
From my older host I have no problems connecting to my server... so I assumed it must be something at my new host, but I'm able to connect to other remote sql servers from my new isp (for example I can connect from my new ISP to the old ISP's SQL server w/o a problem), but for some reason I can't from the new host connect to mine.. is there a setting on mine that needs to change?
newhostwebsvr to oldhostsql works... oldhostwebsvr to mylocalsql works.. newhostwebsvr to mylocalsql doesn't work??
Hi there, I access to server SQL by an application on web,I configured the ODBC box for using TCP/IP and the server use also the TCP/IP. I have this message :
Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL server not found. /medecin/IdentificationAcces/membre_enregistrer.asp, line 108
when trying to install SQL Sever 2005 to windows server 2003 its display the message Windows Installer 3.1 is required. But when tring to install windows installer 3.1 is displays the message Service Pack version of newer than the update that you are applying, Ther is no need to install the update. Why?
Hi,I was hoping someone may be able to shed some light on a SQL2000 connection problem.I have an ASP.NET(1.1) application that connects to a SQL2000 instance on the localmachine, the connection details are as follows: Connection Code :try {//connect to the provided datasource using(SqlConnection connection = new SqlConnection(strConnectionInfo)) { strStatus = "Pulling Data";
SqlDataAdapter sqlA = new SqlDataAdapter("SELECT * FROM NavBlocks",connection); sqlA.Fill(dsNav.NavBlocks);
SqlDataAdapter sqlB = new SqlDataAdapter("SELECT * FROM NavItems",connection); sqlB.Fill(dsNav.NavItems);
bNavLoaded = true;//prevent further calls } }The connection string is as follows: "Data Source=BOBBITSQL2000;Initial Catalog=pinnacleCMS;User Id=myUser;Password=myPass;"Now this conection has never been a problem, the intial catalog exists, the user exists and has permissions, further to this this users connection details can be used to succesfully access the database from a dsn on this machine. The server explorer finds the database fine, Visio finds the databse fine.The problem only existed after I reverse engineered the database into visio (the database was originally developed using Visio), then dropped all of the tables using Enterprise Manager, and re generated the database from within Visio (ddl script) following a few minor changes.Since the re generation I get the server not found error message from the ASP.Net application.I have tried using different network libraries, logging in using the sa account etc, it makes no difference the ASP.Net application cannot see the SQL server instance.Any ideas would be greatly appreciated.p.s. I have tried dropping the firewall with no success, no updates have been installed.Thanks
Yesterday I created a table in Sql Server 2000,using this script： CREATE TABLE [dbo].[User]( [Id] [int] NOT NULL, [UserName] [nvarchar](20) NOT NULL, [TrueName] [nvarchar](20) NOT NULL, [Password] [nvarchar](60) NOT NULL, [Department] [int] NOT NULL, [Mobile] [nvarchar](20) NULL, [Telephone] [nvarchar](20) NULL, [Remark] [nvarchar](200) NULL, [Enabled] [bit] NOT NULL, [Available] [bit] NOT NULL, CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED ( [Id] ASC ) ON [PRIMARY] ) ON [PRIMARY] There was only one record in it: INSERT INTO [User] VALUES(1,N'SUP',N'Jim',N'213123',1,NULL,NULL,NULL,1,1) After I executed this script：UPDATE [User] SET UserName=N'f',TrueName=N'gg',[Password]=N'dfsdfsdf',Mobile=NULL,Telephone=NULL,Remark=NULL, Enabled=1 WHERE [Id]=1 AND Available=1 The value of 'Available' field changed to Zero.That was not supposed to happen. I'm pretty sure it is a bug, because when I did the same thing in Sql Server 2005, everything was correct. Anybody can tell me if this is a known bug? I searched google,but couldn't find any answer. Thanks!
When making a call to MyList.DataSource = products.GetProductCategories(); I get the "SQL Server not found or Access denied" error. Where should I start looking?
Hi, Can any one suggest me how to find a error log when SQL Server Agent is down. I did not find it in NT error log when my SQL Server Agent was shut down. Is it known problem and pls also suggest me for the remedy to this problem. thanks in advance. regards, Narayanan.
