How Do I Connect Client Machines To SQL Server 2005 Installed On A Windows 2003 Server
I am new to SQL server 2005
Windows 2003 Server and all client PCs are all on the same network. I installed SQL 2005 std version on windows server 2003 and created a database and tables in it.
I have two users, who want to connect to SQL server 2005 from their PCs (they have windows XP):
These are two things that I need to facilitate:
1) They want to be able to write queries using Query Designer and run from their PCs.
2) I created an MS Access database on my PC, I want to use Access database as a front end to the SQL server database. I will create queries, forms in Access DB, and I want to be able to get the data from SQL server Database to do this. I guess I can use ODBC to connect to tables in SQL server database.
3) I want to connect SQL server to Oracle database, and run oracle stored procedures. I want to load the results of oracle stored procedures into SQL server database tables. I guess I will use IIS for this.
Any suggestions are appreciated, especially with item number 1.
View Complete Forum Thread with Replies
Related Forum Messages:
Installed SQL Server 2005 In Existing Windows 2003 Domain Server
I would like to ask if it is advisable to install SQL Server 2005 in the existing Windows 2003 Domain Server? Currently our Windows 2003 standard sp2 server has managing multiple server roles which is the File Server, Domain Controller (Active Directory) and DNS Server. Now my co-I.T. installed an SQL Server 2005 in our primary domain server. Here's the problem, a client domain computers(workstation) we are having problem when we log-in, it is very slow when i login. it seems the setting of the AD or DNS was affected or maybe the services. I don't know if SQL Server 2005 are having issues or conflicts into AD, DNS or services.Can somebody give me some advice to this matters. Thanks, razorbex
View Replies !
SQL Server 2005 Client Tools Not Shown Up In Start Menu On Windows 2003 Server
Hello, I have installed SQL server 2005 enterprise edition on Windows 2003 virtual PC (full installation). The installation went through successfully. However, after install completed, I cannot find any of the client tools under the start menu -> all programs -> Microsoft SQL server 2005 menu. The only item listed under the SQL server 2005 is Configuration Tools, which is used to configure the database server. I have tried to install the client component again (in case I didn't install them at the first place) but the installation process cannot be started since it detected that the client components have been installed already. I can also see the sql server native client running in the services. The server engine is working fine since I can connect to that sql server using another machine where I have the client tool (SQL server management studio). One of my friends has exactly the same problem. He installed the sql server 2005 Standard edition on windows 2003 server (full installation), but the client tools are not showing up in the start menu either. I also checked the location for the SQL server management studio (Microsoft SQL server/90/Tools/Binn/VSShell/Common7/IDE), there is only one folder called publicAssemblies listed under. Is this correct or something is missing? Thanks
View Replies !
Does A User Have To Have SQL Server Installed In Order For Windows Form To Connect To SQL 2005 Express DB
Hello, I am creating a windows application that is not going to be used in a controlled environment like a LAN or some other network, so I want to include a local database in the install of this app. Ideally, I would like to use SQL 2005 Express like you would MSDE or Access, but I am not sure if the user must have SQL Server installed on their machine in order for this to work and I don't have a machine without it to test on. Any help on this is greatly appreciated. Thanks, Derek
View Replies !
Can't Connect From A Vista Client To SQL 2005 Box,other Machines Work Fine
Hey. I've a windows vista machine which can't connect to SQL 2005 box. Other machines which are lower than vista work fine. Also, vista box can connect to other SQL 2005 instances but can't connect to only one instance. But, I can connect to the instance fine from my XP box. Also, it's not a permissions issue. This user is an SA and can connect form some other machine. SQL 2005 box is at 2047 version right now. And, the user is able to connect to some other boxes which are also at 2047. Please help. Thank you
View Replies !
SQL Server 2005 Stored Procedures Running On Server 2003 Machines
Stupid question but please be gentle and answer anyway please.... Background: We have SQL Server 2003 (32bit) running on our servers. Our .Net applications (from old release of VS) are still running on them and using the old databases. From what I understand there is no immediate plans to upgrade the servers. However the developers were just given this new upgrade (2005) SQL Server and VS (and fixing depreciated code etc in the .net apps). Question: Can the applications and new stored procedures written via the 2005 environment be deployed successfully on the 2003 Servers? Same goes with Reporting Services?
View Replies !
Windows 2003 Server And Client Installation
hello, i have a windows 2003 server up and running and a client workstation connected via a crossoever cable. they both can ping each other. my next step, i would like to replicate a "real world" scenario where i have the database engine and the sample databases on the server and i would like to be able to write to and from the cleint to main database which is going to be on the server. so my question is, do i need a full install on both machines?
View Replies !
Can't Connect .Net Application From Windows Server 2003 To Database Server (SQL Server 2000)
Hi, I am having a problem connecting my .net applications from the application server to the database server. When I run the application from my windows xp (sp2) box it works fine. When I try to connect via SQL Management Studio to the database server from the application server I get the same error. Here is the error: System.Data.SqlClient.SqlException: 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) Here is the Environment: App Server: Windows Server 2003 Standard Edition Inside Company's Firewall/ Network Database Server: Windows Server 2000 Advanced Edition SQL Server 2000 SP4 Remote Connections to the Server is checked Enable Protocols: Named Pipes & TCP/IP TCP/IP Port: 1402 (I don't know why it isn't the default of 1433) The db server is sitting out side the Company's firewall (don't ask me why). I can access it fine from inside the firewall on my XP box but not from windows server 2003. There is a web server outside the our network that also connects to the db server with no problem and that is running Windows Server 2003 Web Edition. I can ping the db server from the app server using the IP address. I tried using the IP address and the port 1402 in my connection string but that didn't work from any machine (XP and Server). I imagine the issue is somehow related to the company's firewall but why would it only block Windows Server 2003 and not XP? What do I tell the network admin to change? Any help would be appreciated. Thanks, Oran
View Replies !
Cannot Connect To Oracle Using SSIS On Windows 2003 Server With 64 Bit
Hi There, I did everything whatever is mentioned in the below thread. I installed the ODP.Net to connect to oracle. For some reason, if I test the connection using the connection manager in the BI studio, I get connection succeded msg. But If I try to run it and see the progress of the package in SSIS dev environment, I see a 'Class not registered error' or 'Connection not open' error. Can anybody please suggest me any workaround for this? This has been killing me for a number of days.. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=159581&SiteID=1 Thanks.
View Replies !
Cannot Connect To Oracle Using SSIS On Windows 2003 Server With 64 Bit
Hi There, I did everything whatever is mentioned in the below thread. For some reason, if I test the connection using the connection manager in the BI studio, I get connection succeded msg. But If I try to run it and see the progress of the package in SSIS dev environment, I see a 'Class not registered error' or 'Connection not open' error. Can anybody please suggest me any workaround for this? This has been killing me for a number of days.. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=159581&SiteID=1 Thanks.
View Replies !
Can't Connect To SQL2000 On Windows 2003 Server Through UDL Of VB6 Component Of ASP Application
I have problem connecting to a SQL 2000 server that is hosted on a Windows 2003 server. My application uses classic ASP with VB6 components. VB6 components connect to SQL server and return data to ASP application. Everything was working fine when the application and SQL server was hosted on NT machine. Recently we have shifted to Windows 2003 server. Since then we could not establish connection to SQL2000. I'm using UDL as connection string. IIS and SQL2000 hosted on the same machine with Windows 2003 OS. This seems to be a security issue. Earlier I faced this issue for a .net application which I resloved adding a domain account to both SQL server and IIS directory security. Request your input to solve this problem. Sunandajit Ray Infrasoft Technologies Limited
View Replies !
Error &&"Provider Cannot Be Found. It May Not Be Properly Installed.&&" After Deploying Application On Windows 2003 Server
hello folks i have recently started to work with the analysis services and i am having some problems. i have made a web application that for now just tries to connect to an analysis server. The server is installed on an xp sp 2 system. for testing, i used my local computer, which is running also win xp sp2. After deploying, the application can connect to the AS server on the other machine. the problem occurs when i try to deploy the applicatuion on the production server, which is running win 2k3 server on 32 bit. When deploying, i use the same connection string, so it should try to connect to the AS server installed on a win xp sp2 system. The first thing that came to my mind was to check the MDAC versions, be cause of the message: "Provider cannot be found. It may not be properly installed." on my computer, where the application worked ok, the version is MDAC 2.8 SP 1 Windows XP SP 2 on the win2k3 server, the MDAC version is : MDAC 2.8 SP2.... i thought it was the version of the service pack, so o searched for the update of MDAC 2.8 SP1, trying to install mdac 2.8 sp2 to see if i was to see the same error, but i found that mdac 2.8 sp2 is only for win2k3 server, and for win xp is mdac 2.8 sp1, according to this link: http://support.microsoft.com/default.aspx/kb/884103 Now i got confused and have no clues how to make this work... Can anybody give any hint?
View Replies !
Cannot Install SQL Server 2005 On A Windows 2003 Cluster In Virtual Server 2005
I am trying to install SQL 2005 in a 2-node virtual Windows 2003 cluster. I set the cluster up through Virtual Server 2005 with 2 virtual nodes and one virtual domain. The nodes can connect to each other as well as the physical machine. When I try to install a fresh copy of SQL 2005 on my cluster, I get an error every time. The error stops the installation while checking system configuration after installing prerequisites. The log file entry is as follows: ******************************************* Setup Consistency Check Report for Machine: --SERVERNAME-- ******************************************* Article: WMI Service Requirement, Result: CheckPassed Article: MSXML Requirement, Result: CheckPassed Article: Operating System Minimum Level Requirement, Result: CheckPassed Article: Operating System Service Pack Level Requirement, Result: CheckPassed Article: SQL Compatibility With Operating System, Result: CheckPassed Article: Minimum Hardware Requirement, Result: CheckPassed Article: IIS Feature Requirement, Result: Warning Description: IIS is not installed, therefore Report Server feature will be disabled Action: Install IIS in order for Report Server feature to be enabled Article: Pending Reboot Requirement, Result: CheckPassed Article: Performance Monitor Counter Requirement, Result: CheckPassed Article: Default Installation Path Permission Requirement, Result: CheckPassed Article: Internet Explorer Requirement, Result: CheckPassed Article: Check COM+ Catalogue, Result: CheckPassed Article: ASP.Net Registration Requirement, Result: CheckPassed Article: Minimum MDAC Version Requirement, Result: CheckPassed <Func Name='PerformDetections'> 1 Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll Version:2005.90.1399.0 Error: Action "InvokeSqlSetupDllAction" threw an exception during execution. Error information reported during run: Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "ComputerList" {"SqlComputers", "", ""} in cache Source File Name: datastoreclusterinfocollector.cpp Compiler Timestamp: Fri Sep 16 13:20:12 2005 Function Name: ClusterInfoCollector::collectClusterVSInfo Source Line Number: 883 ---------------------------------------------------------- Failed to detect VS info due to datastore exception. Source File Name: datastoreclustergroupsproperties.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: ClusterGroupScope.SharedDisks Source Line Number: 56 ---------------------------------------------------------- Failed to find a cluster group that owned shared disk: J: WinException : 2 Error Code: 0x80070002 (2) Windows Error Text: The system cannot find the file specified. Source File Name: datastoreclustergroupsproperties.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: ClusterGroupScope.SharedDisks Source Line Number: 56
View Replies !
SQL Server 2000 + 2005 Working On Same Windows 2003 Server As Seperate Instances
Hi all,I just asked some people to help me out and phone microsoft with thefollowing information, kindly they refused unless we setup a supportcontract with them first, for pre-sales information. (That really doesnot sound like good business sense to me - anyway here is our problem,if anyone could help thanks)."To tell and ask microsoft:We will be setting up a microsoft sql server 2000 instance running on awindows 2003 server.1) We need to check this can run alongside a microsoft 2003 sql server(either workgroup or standard edition), on the same machine. Are thereany .dll clashes if we do this? If there are can we run SQL Server2000, in a virtual machine running windows 2000 professional. (I have alicenced copy we can use for this).2) If we run one instance of 2000, and one of 2003 of the sql servers,can one use the processor licence model, and one use the CAL licencemodel."Thanks for any help, and any idea why they actually force you to usenews groups for pre-sales information?David
View Replies !
Problem Installing SQL Server 2005 Enterprise Edition On Windows Server 2003 Box
While attempting to install SQL Server 2005 Enterprise Edition on a Windows Server 2003 box, it is failing as follows... Microsoft SQL Server 2005 Setup beginning at Thu Sep 20 11:11:35 2007 Process ID : 5440 E:setup.exe Version: 2005.90.1399.0 Running: LoadResourcesAction at: 2007/8/20 11:11:35 Complete: LoadResourcesAction at: 2007/8/20 11:11:35, returned true Running: ParseBootstrapOptionsAction at: 2007/8/20 11:11:35 Loaded DLL:E:xmlrw.dll Version:2.0.3604.0 Complete: ParseBootstrapOptionsAction at: 2007/8/20 11:11:35, returned false Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run: Could not parse command line due to datastore exception. Source File Name: utillibpersisthelpers.cpp Compiler Timestamp: Fri Jul 29 01:13:55 2005 Function Name: writeEncryptedString Source Line Number: 124 ---------------------------------------------------------- writeEncryptedString() failed Source File Name: utillibpersisthelpers.cpp Compiler Timestamp: Fri Jul 29 01:13:55 2005 Function Name: writeEncryptedString Source Line Number: 123 ---------------------------------------------------------- Error Code: 0x80070002 (2) Windows Error Text: The system cannot find the file specified. Source File Name: cryptohelpercryptsameusersamemachine.cpp Compiler Timestamp: Mon Jun 13 14:30:00 2005 Function Name: sqls::CryptSameUserSameMachine:rotectData Source Line Number: 50 2 Could not skip Component update due to datastore exception. Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "5440"} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:50 2005 Function Name: SetupBootstrapOptionsScope.InstallMediaPath Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupBootstrapOptionsScope" Running: ValidateWinNTAction at: 2007/8/20 11:11:35 Complete: ValidateWinNTAction at: 2007/8/20 11:11:35, returned true Running: ValidateMinOSAction at: 2007/8/20 11:11:35 Complete: ValidateMinOSAction at: 2007/8/20 11:11:35, returned true Running: PerformSCCAction at: 2007/8/20 11:11:35 Complete: PerformSCCAction at: 2007/8/20 11:11:35, returned true Running: ActivateLoggingAction at: 2007/8/20 11:11:35 Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run: Datastore exception while trying to write logging properties. Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:50 2005 Function Name: SetupStateScope.primaryLogFiles Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupStateScope" 00CFCFC8Unable to proceed with setup, there was a command line parsing error. : 2 Error Code: 0x80070002 (2) Windows Error Text: The system cannot find the file specified. Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:50 2005 Function Name: SetupBootstrapOptionsScope.InstallMediaPath Source Line Number: 44 Failed to create CAB file due to datastore exception Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "5440"} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:50 2005 Function Name: SetupBootstrapOptionsScope.HostSetup Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupBootstrapOptionsScope" Message pump returning: 2 Any ideas? Thanks in advance.
View Replies !
SQL Server Reporting Services 2005 Service Would Not Start On Windows Server 2003
SQL Server Reporting Services 2005 Service would not Start on windows server 2003. Working great till yesterday and no changes were made to config file. Here is the error in Event log Event Type: Error Event Source: SQL Server Report Service Event Category: None Event ID: 0 Date: 12/13/2007 Time: 8:25:59 AM User: N/A Computer: XXXXXXXXXXX Description: Service cannot be started. Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information. at Microsoft.ReportingServices.Library.ServiceAppDomainController.Start(Boolean firstTime) at Microsoft.ReportingServices.NTService.ReportService.OnStart(String[] args) at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state) For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Here is i found in log files ReportingServicesService!resourceutilities!4!12/13/2007-08:25:59:: i INFO: Running on 0 physical processors, 1 logical processors ReportingServicesService!servicecontroller!4!12/13/2007-08:25:59:: e ERROR: Exception caught loading and setting code permissions policy level: System.Security.XmlSyntaxException: Invalid syntax on line 158. at System.Security.Util.Parser.GetRequiredSizes(TokenizerStream stream, Int32& index) at System.Security.Util.Parser.ParseContents() at System.Security.Util.Parser..ctor(Tokenizer t) at System.Security.SecurityManager.LoadPolicyLevelFromStringHelper(String str, String path, PolicyLevelType type) at System.Security.SecurityManager.LoadPolicyLevelFromString(String str, PolicyLevelType type) at Microsoft.ReportingServices.Library.ServiceController.SetAppDomainPolicy() ReportingServicesService!servicecontroller!4!12/13/2007-08:25:59:: e ERROR: Error Starting Service: System.Security.XmlSyntaxException: Invalid syntax on line 158. at System.Security.Util.Parser.GetRequiredSizes(TokenizerStream stream, Int32& index) at System.Security.Util.Parser.ParseContents() at System.Security.Util.Parser..ctor(Tokenizer t) at System.Security.SecurityManager.LoadPolicyLevelFromStringHelper(String str, String path, PolicyLevelType type) at System.Security.SecurityManager.LoadPolicyLevelFromString(String str, PolicyLevelType type) at Microsoft.ReportingServices.Library.ServiceController.SetAppDomainPolicy() at Microsoft.ReportingServices.Library.ServiceController.StartService(Boolean firstStart)
View Replies !
Distributed Transaction Does Not Work With SQL Server 2005 On Windows Server 2003
Hi,I'm having problems trying to put triggers working between SQL Server 2005 connected by linked servers.I'm using two SqlServer 2005 both running on Windows Server 2003 Standard Edition SP1.Both doesn't belongs to a Domain. They are configured in they own workgroup. Microsoft SQL Server Management Studio 9.00.2047.00Microsoft Analysis Services Client Tools 2005.090.2047.00Microsoft Data Access Components (MDAC) 2000.086.1830.00 (srv03_sp1_rtm.050324-1447)Microsoft MSXML 2.6 3.0 5.0 6.0 Microsoft Internet Explorer 6.0.3790.1830Microsoft .NET Framework 2.0.50727.42Operating System 5.2.3790MSDTC version 5.2.3790.1830 What I checked on both servers: - Service "Remote Procedure Call" is running using the account "NT AUTHORITYNetworkService"; - On Component Services -> Computer -> My Computer Properties -> tab MSDTC -> Security Configuration all box are checked. On the Transaction Manager Communication the chosen is "No Authentication is Required". - On Local Computer Policy -> Administrative Templates -> System -> Remote Procedure Call the "Restriction for Unauthenticated RPC clients" is enabled and the restriction to apply is "None". - Windows Firewall is disabled - Registry key is set to HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSDTCTurnOffRpcSecurity is set to "1" Schema on server [myServer2]: USE [myDB]GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[myTable]( [code] [varchar](5) NOT NULL, [name] [varchar](10) NULL,PRIMARY KEY CLUSTERED ( [code] ASC)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFF SQLStatement run on server [myServer1] begin distributed transactioninsert into [myServer2].myDB.dbo.myTable values ('ACD','LX')commit transaction The error message: OLE DB provider "SQLNCLI" for linked server "myServer2" returned message "No transaction is active.".Msg 7391, Level 16, State 2, Line 2The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "myServer2" was unable to begin a distributed transaction. Some one can help me find the problem?Thank you in advanceJoao
View Replies !
How To Install Sql 2005 Server Express On Windows Server 2003 X64 Edition
hi everyone, can anyone help me how to install sql 2005 server express edition on windows server 2003 x64 edition. because its my first time installing on a 64 bit OS i dont know how. When i tried installing it gives a warning on ASP.Net , when i ignore that & continue the installation. when installing now the SQLServer Management Studio Express now it says "installation of this product failed because it is not supported on this qperating system....." any idea?
View Replies !
Oracle/Unix Environments --&&> SQL Server 2005/Windows 2003 Server
I was a Oracle Developer / DBA on Unix Environments all along my career, Very recently iam starting to manage a SQL Server 2005/Windows 2003 Server setup. Part of my new job is to automate to load Huge Data files/Flat Files (3/4 GB in size) into SQL Server 2005 DB. Have these initial questions.. Since the files are too large to open at once... What sort of Command Line Interfaces people use on the Windows Boxes.. like doing a "wc" (Word Count) / GREP 'ng Files / Massaging Data Files one line at a time (Like using SED / AWK Commands).. Etc Any Input / Direction is appreciated...
View Replies !
MSDTC - Remote Accessing SQL Server 2005 From A Desktop Application - Windows 2003 Server
Hi, I am developing a windows application that needs to communicate with a remote SQL server 2005 database. Server allows remote connections and MSDTC service also running. Do I need to run MSDTC service on the client machine where I use desktop application ? any ideas ? It's throwing some error like 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. But my SQL Server allows remote connection, and I am able to do a select statement. But when I insert/update anything, it's throwing this error. I guess some problem with MSDCT. Anybody have any idea ?
View Replies !
Setup Issue: Unable To Install SQL Server 2005 Express On Windows 2003 Server SP2
Hello Experts, I have been unable to install SQL Express 2005 Server on my Windows 2003 Server (with SP2 installed). I keep getting an error message saying that Microsoft Windows Installer 3.1 is not installed. Click here for image So, I downloaded Microsoft Windows Installer 3.1 v2 (WindowsInstaller-KB893803-v2-x86.exe) but whenever I try to install it I get an error message saying that "the Service Pack version of this system is newer than the update you are applying" and that there is no need to install the update and it stops there. Click here for image Is there a workaround to this? How can I get Microsoft Windows Installer 3.1 installed? I tried going to the Windows Update site, I already have everything installed and I even started the Windows Installer service manually. Has anyone else experienced this? How can I get SQL Server 2005 Express installed if not how can I install SQL Server 2000 on tihs machine? The only reason I am trying to install SQL Server 2005 is because wanted to try it so I uninstalled SQL Server 2000 now I can no longer install SQL Server 2000 again because it won't let me because of the SP2 patch. Help! :(
View Replies !
AntiVirus Suggestions On SQL Server 2005 Box (Windows Server 2003 R2)
Hi all, I know there's been quite a bit of discussion on WHETHER to run antivirus software on a SQL box(http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1764423&SiteID=1). If I do decide to run it, does anyone have suggestions of specific antivirus software that have worked well and did not cause significant performance problems? Thanks in advance. --Jim
View Replies !
Windows Server 2003 Password Policy And SQL Server 2005
I have a complicated question that involves the password policy defined within Windows Server 2003 and how it is used in Microsoft SQL Server 2005. I recently installed windows server 2003 on my development system. I am a person that prefers to develop in the same OS that our application runs in production. After installing 2003, then a Domain administrator added my machine to our corporate domain. Now, I cannot change the local password policy to allow a simple password. I believe this is due to policy inheriting from the domain that the machine belongs to. This ties back into SQL Server 2005 because installing sql server on a Server 2003 causes SQL Server 2005 to follow the password policies defined at the OS level. This breaks our application in a subtle way in that we create login accounts for new client databases with random password. Because the password is random it sometimes conforms to the policy and sometimes not. In production environments, the password policies are configured differently. So I need to one of the following options: -change the group policy/inherited policy on my machine to not inherity from the domain I joined (prefered solution but don't know HOW) -change SQL Server to not use OS password policy -change code to use CREATE LOGIN statement with CHECK_POLICY=OFF or change password generation code to use a stronger password. (don't want to do this as the code change is only accomodating non-production environments) If someone has a better place to post this question, I would sure appreciate it.
View Replies !
SQL Server 2005 (x64) Fail To Install On Windows Server 2003 R2 (x64).
I tried to install SQL Server 2005 (x64) Standard Edition on Windows Server 2003 R2 (x64) Standard Edition. My box meet the requirement. But I got the following error when the installing progress was just about to begin: Error 1016:Could not access network location k.3643236F_FC70_11D3_A536_0090278A1BB8]URTVersio. (this is exactly what i saw in the system log) what does it mean?? i am totally confused...what the hell is the k.3643236F_FC70_11D3_A536_0090278A1BB8]URTVersio???? Can anybody give me a hand? thanks...
View Replies !
Trouble Installing SQL Server 2005 X64 On Windows Server 2003 R2 X64
I'm having trouble installing SQL Server 2005 x64 Enterprise Edition on Windows Server 2003 R2 x64 Enterprise Editions with SP2 in a failover cluster. The summary log at the end says: Code SnippetMicrosoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 2 (Build 3790) Time : Thu Aug 23 11:32:37 2007 HAVWA233 : The feature(s) specified are not valid for this edition of SQL Server. All I can find about SQL Server 2005 x64 on Windows 2003 x64 is that 2003 should be SP1. See http://msdn2.microsoft.com/en-us/library/ms143506.aspx Has anyone else encounter this issue? We have already successfully installed SQL Server 2005 x64 on Windows 2003 with SP1 in the past, just wondering if having the server at SP2 is causeing the compatibilty issue?
View Replies !
Sql Server 2005 Express Backup On Windows 2003 Server
I note that after installing sql server 2005 express onto a Windows 2003 server from a Windows XP pro computer I lose the ability to backup, specifically, the microsoft sql studio express lost or is missing the function (management -> Management plans) which allows for backups to be run at specified times. How can I proceed to backup my SQL server 2005 express database ? Thanks, David
View Replies !
No Services Installed With SQL Server 2005 Enterprise On Windows XP SP2
Hello, I started out with SQLExpress and that installed just fine. After going through some books about SQL, I found out the limitations to SQLExpress and realized that I would need the full version if I was to further my education on this. (analysis services, integration services, etc etc.) I uninstalled SQLExpress and downloaded and installed SQL Server 2005 (Enterprise Edition I believe). I have installed SQL Server 2005 and I went to go connect. It says it requires a Server Name. So I put the local name of the computer in there and came back with an Error 40. During the troubleshooting of what is causing this error I discovered there are no Services installed from SQL Server 2005. They were removed when I removed SQLExpress and not reinstalled when I installed SQL Server 2005. I checked in both the Services Icon in Administrative Tools and in the SQL Server Configuration Manager. This would account for my not being able to connect to a local server. How do I bring them back. I have uninstalled and reinstalled SQL Server 2005 3 times now. It doesn't bring them back. Now, apparently Enterprise edition does not run on Windows XP Pro SP2. Is there anyway around this? I heard something about a manual installation from the CD but I didn't understand what he was attempting to say. http://www.dbtalk.net/microsoft-public-sqlserver-setup/no-services-components-installed-292167.html Thanks, Wayne
View Replies !
Unable To Connect To SQL SERVER 2005 Database Engine Using Windows Authentication Under Windows Vista...
Hallo there, I just upgraded from Windows XP Pro to Windows Vista Bussiness and tried to reinstall SQL Server 2005 Developers Edition. After the installation i downloaded (using microsoft windows update) and installed all the service packs for sql and vista available. My problem is when i open sql server management studio and try to connect to my default instance using windows authentication and database engine, an 18456 error occurs. I enabled all the protocols and all the ports I disabled windows firewall and antivirus (eset nod32) I installed all service packs available I have also installed Visual Studio 2005 without installing sqlexpress But nothing happens! Please i am very desperate, any information will be gratefully accepted. This is my installation Information Code Snippet Microsoft SQL Server Management Studio 9.00.3042.00 Microsoft Analysis Services Client Tools 2005.090.3042.00 Microsoft Data Access Components (MDAC) 6.0.6001.18000 (longhorn_rtm.080118-1840) Microsoft MSXML 3.0 5.0 6.0 Microsoft Internet Explorer 7.0.6001.18000 Microsoft .NET Framework 2.0.50727.1434 Operating System 6.0.6001 Thank you in advance, Patonios
View Replies !
Question About &&"Connect To The Sql Server 2000 Installed On Windows Xp Sp2&&"
Hi I have another question now. As the topic said, my sql server 2000 installed on windows xp sp2, the computer's name is "ADMIN" and the server 2000's name is "ADMIN". When i startup the sql server 2000, it just listening on shared memory and name pipes, not including the "TCP/IP" . So i can not connect to the sql server using the port 1433. Some people said that the reason was the system's firewall. I also found some supports on the websites 'www.support.microsoft.com'. It said that you can set the port 1433 or the sqlservr.exe to the execption. I also do that, but still not works. Is there any things i forget and how can i solve the problems! Thanks for advances.
View Replies !
SQL Server Express And Client App Both On Win XP Machines ?
Hi, Can I access from App machine (on WinXP) to SQL 2005 Exp machine (on WinXP) ? I installed SQL 2005 Exp SP2 on Win XP SP2 on my PC. Please consider following environment: - My PC name: MyPC - Database name : MyData - Database role for MyData without any permissions: MyDBRole - Application role for MyData having all permisions: MyAppRole - Database user: MyDBUser - SQL Login: MyLogin (WinXP Limited Login) mapped to MyDBUser - Application Name to access MyData: MyApp - Using Application Role MyRole in MyApp I am accessing data from MyApp within MyLogin. When I want to access from other tool like Management Studio Express, I can not access it and that that is what I want. Till now it is OK when I am doing all these things on MyPC. Now question is : Is it possible to connect from other PC (say CleintPC) running Windows XP SP2 use MyApp ? I think ClientPC should access MyPC through MyPC's MyLogin. [ I have tried successful simple SQL server connection with MyPC's Guest Login] Please tell me is it possible ? (Running SQL Express on one machine, Application on second machine and both machine's operationg system is Windows XP) Thanks
View Replies !
Installing SQL Server 2005 To Windows Server 2003
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?
View Replies !
MS SQL 2005 + Windows Server 2003 SP2
At first I thought it was just me, but has anyone else noticed that SQL 2005 suffers a performance hit when you install Windows Server 2003 SP2? Since SP2, memory and hard drive usage has gone through the roof on a number of servers I use. It may just be coincidence... but it seems unlikely.
View Replies !
Sql Server 2005 On Windows 2003 RC2 .? Will This..
Hi, Our customer is going to migrate Sql server 2000 standard (on windows 2000 server) to Sql server 2005 standard (on windows 2003 RC2) will sql server 2005 stand. run correclty on windows 2003 RC2. does sql server 2005 neeed any service pack for windows 2003 RC to run correclty please help
View Replies !
Connect To MDF File Without Having SQL Server 2005 Express Installed
All -- Please help. Is it possible to connect to MDF file without having SQL Server 2005 Express installed on the machine? That is-- can one connect directly to an MDF in the same way and Access MDB file can be used? If no, then is there any way around this? If yes, then are there any limitations? Please advise. Thank you. -- Mark Kamoski
View Replies !
ODBC Connection For Client Application To SQL Server 2005 Express Installed On Network Computer
Hi All, I've developed an application that connects to a SQL Server 2005 Express database. I created a DSN to connect to the database through ODBC. Currently, I am testing locally and everything works fine. I would now like to install my application on another workstation and connect remotely to the database located on my development machine. The client workstation does not have SQL Server 2005 Express installed on it because I would just like my application to connect remotely by creating the DSN and using ODBC. What I'm missing here are the database drivers. The "SQL Natice Client" is not available on this client workstation. How can I deploy the necessary drivers with my installation file so that I may create the required DSN name using the SQL Native Client driver? Thanks!
View Replies !
Cannot Install SQL 2005 On Windows Server 2003
I'm unable to successfully install SQL 2005 on Windows Server 2003. Everything installs correctly except 'SQLXML4', and after installation, there's no Management Studio, unless I then install SQL Express Management Studio. Installation details: Successfully installs 'Native Client' and the 'Support Files'. The 'System Configuration Check' passes everything. Installed 'Database Services', 'Integration Services', 'Client Components' (except for the 2 development tools), and 'Books Online'. Created the default instance (there were no other instances). Set it to run as 'Local System'. Set only the 'SQL Server' service to start after setup. Specified 'Mixed Mode'. Then the installation proceeds, and everything looks good until SQLXML4 fails. Soon after, a window pops up saying "Setup is preparing to continue with the installation". Nothing happens till I click 'OK', and then 'Workstation Components' shows as having failed. Then the installation finishes normally. However there's no Management Studio, except that I then installed the SQL Express Management Studio, which appears to work fine. I tried uninstalling, and installing again, but got the same results. How can I get this to install correctly? Thank you.
View Replies !
How To Reinstall SQL 2005 In Windows Server 2003 For SBS?
I've got a Windows Server 2003 for Small Business Server. It had got SQL installed. But then SQL was uninstalled. Now I need to put SQL back in, but I don't see how! There're three CD-Rom but I don't see how and from which CD to install back SQL. PS: Correct me if I'm wrong, Windows Server 2003 is sold with SQL 2005, right?
View Replies !
Connecting Sql Server 2005 On Windows 2003 Using ASP Local
Hello!I'm migrating an IIS/SQL-Server application from Windows NT4.0 and SQL-Server 2000 to Windows 2003 Server and SQL-Server 2005.My problem is that it is not possible to connect local (IIS and SQL-Server 2005 are runnng on the same node) using ODBC. Running theapplikation on a remote IIS (XPPro) all works fine. I can't see anydifferences in the ODBC-configuration.Any idea?Thanks
View Replies !
Error Installing MS SQL 2005 On Windows 2003 Server With SP2
I get and error when installing MS SQL 2005 on Windows 2003 server with SP2. It bombs at the very end of the install and Microsoft notification program generated he message below to be sent to Microsoft. Please help. At a stand still. ------------------------------------------------------------------------------------------------------------------- EventType : sql90setup P1 : unknown P2 : 0x645 P3 : unknown P4 : 0x645 P5 : unknown P6 : unknown P7 : sqlserver2005_bc.msi@ Below is the summary.txt ------------------------------------- Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Microsoft Windows Server 2003 family, Standard Edition Service Pack 2 (Build 3790) Time : Thu Feb 28 22:52:28 2008 Machine : ESAPPS Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : ESAPPS Product : Microsoft SQL Server Native Client Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : ESAPPS Product : Microsoft Office 2003 Web Components Product Version : 11.0.6558.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_OWC11_1.log -------------------------------------------------------------------------------- Machine : ESAPPS Product : MSXML 6.0 Parser Product Version : 6.00.3883.8 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_MSXML6_1.log -------------------------------------------------------------------------------- Machine : ESAPPS Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_SQLSupport_2.log -------------------------------------------------------------------------------- Machine : ESAPPS Product : Microsoft SQL Server Native Client Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_SQLNCLI_2.log -------------------------------------------------------------------------------- Machine : ESAPPS Product : Microsoft Office 2003 Web Components Product Version : 11.0.6558.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_OWC11_2.log -------------------------------------------------------------------------------- Machine : ESAPPS Product : Microsoft SQL Server VSS Writer Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : ESAPPS Product : MSXML 6.0 Parser Product Version : 6.00.3883.8 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_MSXML6_2.log -------------------------------------------------------------------------------- Machine : ESAPPS Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_SQLSupport_3.log -------------------------------------------------------------------------------- Machine : ESAPPS Product : Microsoft SQL Server Native Client Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_SQLNCLI_3.log -------------------------------------------------------------------------------- Machine : ESAPPS Product : Microsoft Office 2003 Web Components Product Version : 11.0.6558.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_OWC11_3.log -------------------------------------------------------------------------------- Machine : ESAPPS Product : Microsoft SQL Server 2005 Books Online (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_BOL_1.log -------------------------------------------------------------------------------- Machine : ESAPPS Product : MSXML 6.0 Parser Product Version : 6.00.3883.8 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_MSXML6_3.log -------------------------------------------------------------------------------- Machine : ESAPPS Product : SQLXML4 Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_SQLXML4_1.log -------------------------------------------------------------------------------- SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt. Time : Thu Feb 28 23:01:11 2008 List of log files: C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_Core(Local).log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_SQLSupport_1.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_SQLNCLI_1.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_OWC11_1.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_BackwardsCompat_1.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_MSXML6_1.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_SQLSupport_2.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_SQLNCLI_2.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_OWC11_2.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_SqlWriter_1.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_MSXML6_2.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_SQLSupport_3.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_SQLNCLI_3.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_OWC11_3.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_BOL_1.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_MSXML6_3.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_SQLXML4_1.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_Datastore.xml C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_.NET Framework 2.0.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_Core.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_.NET Framework 2.0 LangPack.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_.NET Framework Upgrade Advisor.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_.NET Framework Upgrade Advisor LangPack.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_.NET Framework Windows Installer.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_.NET Framework Windows Installer LangPack.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_Support.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_SCC.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_WI.log
View Replies !
|
TRACKER
