Windows Backup And SQL 2005

Feb 8, 2007

I know I've been posting a lot about another problem but you all have been most helpful so I thought I'd throw this one at you too.

My nephew's company has a server with Small Business Server 2003 SP1 and they run Windows Backup for their daily backups. They also have SQL 2005 Workgroup on that machine. Prior to SQL 2005, they ran SQL 7 and had no problems with their daily backups. Once they upgraded (clean installed actually) SQL 2005 their backups fail. The event log errors with Event ID 6013 and says:

SQLlib error: OLEDB Error encountered calling IDBInitialize::Initialize. hr=0x80004005 SQLSTATE: 08001, Native Error: 17 Error state: 1, Severity: 16
Source: Microsoft OLE DB Provider for SQL Server
Error Message: [DBNETLIB][ConnectionOpen[Connect[]].]SQL Server does not exist or access denied.

Obviously, SQL Server does exist, so I presume it has to do with an access denial. Microsoft has been no help and Googling other sites have gotten nowhere. DLL updates have been done and hot fixes installed. But the error persists.

Any ideas of where he should look?

Thanks in advance

Dave

View 3 Replies


ADVERTISEMENT

Can Windows 2003 Server Backup Utility Be Used To Backup A SQL 2000 Dbase

Dec 28, 2007

Windows 2003 backup utility uses the shadow copy option that allows it to copy open files.
Therefore, can I use this utility to backup the .mdf and .ldf files for my SQL 2000 database?
I can then attach the .mdf files if I need to restore the database to another server.
Can anyone tell me if this is safe? I've tried it and it worked but I'm worried there maybe some lurking danger in using this approach.

View 4 Replies View Related

Sql Server 2005 Express Backup On Windows 2003 Server

Jul 11, 2007

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 3 Replies View Related

Unable To Connect To SQL SERVER 2005 Database Engine Using Windows Authentication Under Windows Vista...

Mar 26, 2008

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 3 Replies View Related

Backup Using Windows Account

Aug 3, 2006

I have a scheduled job to perform exports of SQL databases to a file share. The file share is setup so everyone can write to it but only the AD account 'SQL.Bkup' can delete. I have setup SQL Server Agent to use this ID when performing backups but the backups fail each time when trying to delete old backup versions.

I have logged into this id (SQL.Bkup) and can delete files on that share without a problem.

Is there some thing I need to setup differently to get the backup process tol run with the correct authority?

Thanks,
Ken Nicholson

View 5 Replies View Related

Backup ODBC On Windows 2000 Server?

Jul 6, 2004

howto backup ODBC configure and data on windows 2000 server help me!
thanks.

View 6 Replies View Related

SQL Server 2000 - Run Transaction Log Backup Using Windows CMD File

Mar 19, 2007

How I can run a SQL Server Transaction Log Backup using a Windows CMD File.  It's that posible?  Anyone know the command or how do this?

We already have a application monitoring our SQL databases.  Everytime the transaction log get full, it sends us an alert.  Would be better if our application repair the problem itself, executing a command (Windows CMD File).

I'm not a expert using SQL databases or MS DOS Prompt commands.

Any help will be appreciate.

View 1 Replies View Related

Difference Between Partial Backup (SQL 2005) And File Group Backup

Dec 5, 2006

What is the difference between "Files aned File Groups" backup and Partial Backup?

Looks like both are same.. Please comment.

View 3 Replies View Related

How SQL SERVER 2005 Backup && ArcServe Backup Coexist ??

Apr 15, 2008

I have only one tape drive.
My server is using the SQL server 2005 backup tool and arcserve backup tool to backup different files .

Everytime I need to disable and enable the tape device driver (in device manager /windows) before I can use SQL server 2005 backup tool.

Everytime I need to disable and enable the tape device driver (in device manager /windows) before I can use arcserve backup tool.

It seems that the tape device resource is held by softwares even the tape drive is not in use.

What should I do to make the tape drive shared by different softwares?


Regards,
Manuel

View 2 Replies View Related

Merge Replication - SQL Server 2005, Windows Vista And MSVisual Studio 2005

Jul 11, 2007

Hello everybody!

I hope that someone could help me.

I have a problem when i start sincronyzing with the emulator of MSVS2005 to SQL2005 in Windows Vista. I have the same program in the emulator, but sincronyzing with windows XP Pro and no problem...



I configure the connection to use the IUSR.



The source code that i use:



repl.InternetUrl = @"http://laptop/SQLMobileIIS/sqlcesa30.dll";

repl.Publisher = @"laptop";

repl.PublisherDatabase = @"database";

repl.PublisherSecurityMode = SecurityType.NTAuthentication;

repl.Publication = @"Pubdatabase";

repl.Subscriber = @"SQLMobile";

repl.SubscriberConnectionString = @"Data Source='" + nomeFicheiroBD + "';Password='3409'";



The error that returns is:



"Failure to connect to SQLServer 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"



Does anybody knows what i can do?

HELP I NEED SOMEBODY TO HELP!

Thanks!

View 1 Replies View Related

Vista SQL 2005 SP2 Client To Windows XP SQL 2005 (non-sp2) Workstation.

Apr 26, 2007

I'm trying to use SQL Management Studio to connect from a Vista SQL 2005 client w/ SP2 over to a Windows XP workstation running SQL server developer edition (non-sp2) using windows authentication.



I'm already preauthenticated by network shares to the xp workstation. This worked just fine in windows xp but stop working in vista.



After searching around, i found out that vista handles trusted authentication differently than windows xp due to changes in the SSPI. Logging in as sql authentication works fine. Logging in as windows authentication does not.



UPDATE: I found out that two workstations running vista and sql 2005 sp2 cannot connect to each other using windows trusted authentication!!!



What the heck?



UPDATE: I found out that my IIS 7.0 using ASP.NET and connecting to SQL 2005 (non sp2) on a Windows 2003 server (SP1) WILL connect to the database using trusted authentication... apparently IIS can access the credentials and pass them to the sql 2005 box just fine. My Sql 2K5 SP2 tools cannot. I'm forced to use SQL authentication to the box.



Same thing applies with a Windows XP SP2 box running SQL 2005 (non sp2).


Here is my sql server error log off of the windows xp workstation:

2007-04-26 15:41:32.34 Logon Error: 17806, Severity: 20, State: 2.
2007-04-26 15:41:32.34 Logon SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 192.168.254.100]
2007-04-26 15:41:32.34 Logon Error: 18452, Severity: 14, State: 1.
2007-04-26 15:41:32.34 Logon Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 192.168.254.100]




How can i Fix this issue?



[1] Client side:

What is the connection string in you app or DSN?
N/A
If client fails to connect, what is the client error messages?

Is the client remote or local to the SQL server machine?
Remote

Can you ping your server?
YES

Can you telnet to your SQL Server?
YES

What is your client database provider?
SQL Management Studio

Is your client computer in the same domain as the Server computer?
WorkGroup

What protocol the client enabled?
Shared Memory & TCPIP

Do you have aliases configured that match the server name portion of your connection string?
NO

Do you select force encryption on server and/or client?
NO

[2] Server side:



What is the MS SQL version?
SQL Server 2005

What is the SKU of MS SQL?
Developer

What is the SQL Server Protocol enabled?
Shared Memory & TCPIP

Does the server start successfully?
YES

If SQL Server is a named instance, is the SQL browser enabled?
N/A

What is the account that the SQL Server is running under?
Network Service

Do you make firewall exception for your SQL server TCP port if you want connect remotely through TCP provider?
YES

Do you make firewall exception for SQL Browser UDP port 1434?
N/A

[3] Platform:

What is the OS version?
Client - Windows Vista Final w/ SQL Server 2005 SP2 & Network Client SP2

Server - Windows XP Professional SP2 w/ SQL 2005 Server Developer Edition

Do you have third party antivirus, anti-spareware software installed?
None

[4] Misc:

If you have certificate configuration issue: Please use €ścertutil.exe €“v €“store my€? to dump certificate specific info and post it in your question.
N/A

Tips:

1. Find SQL Server Errorlog: Default to C:Program FilesMicrosoft SQL ServerMSSQL.#MSSQLLOG

2007-04-26 15:41:32.34 Logon Error: 17806, Severity: 20, State: 2.
2007-04-26 15:41:32.34 Logon SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 192.168.254.100]
2007-04-26 15:41:32.34 Logon Error: 18452, Severity: 14, State: 1.
2007-04-26 15:41:32.34 Logon Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 192.168.254.100]






[1] Client side:

What is the connection string in you app or DSN?
N/A
If client fails to connect, what is the client error messages?

Is the client remote or local to the SQL server machine?
Remote

Can you ping your server?
YES

Can you telnet to your SQL Server?
YES

What is your client database provider?
SQL Management Studio

Is your client computer in the same domain as the Server computer?
WorkGroup

What protocol the client enabled?
Shared Memory & TCPIP

Do you have aliases configured that match the server name portion of your connection string?
NO

Do you select force encryption on server and/or client?
NO

[2] Server side:



What is the MS SQL version?
SQL Server 2005

What is the SKU of MS SQL?
Developer

What is the SQL Server Protocol enabled?
Shared Memory & TCPIP

Does the server start successfully?
YES

If SQL Server is a named instance, is the SQL browser enabled?
N/A

What is the account that the SQL Server is running under?
Network Service

Do you make firewall exception for your SQL server TCP port if you want connect remotely through TCP provider?
YES

Do you make firewall exception for SQL Browser UDP port 1434?
N/A

[3] Platform:

What is the OS version?
Client - Windows Vista Final w/ SQL Server 2005 SP2 & Network Client SP2

Server - Windows XP Professional SP2 w/ SQL 2005 Server Developer Edition

Do you have third party antivirus, anti-spareware software installed?
None

[4] Misc:

If you have certificate configuration issue: Please use €ścertutil.exe €“v €“store my€? to dump certificate specific info and post it in your question.
N/A

Tips:

1. Find SQL Server Errorlog: Default to C:Program FilesMicrosoft SQL ServerMSSQL.#MSSQLLOG

2007-04-26 15:41:32.34 Logon Error: 17806, Severity: 20, State: 2.
2007-04-26 15:41:32.34 Logon SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 192.168.254.100]
2007-04-26 15:41:32.34 Logon Error: 18452, Severity: 14, State: 1.
2007-04-26 15:41:32.34 Logon Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 192.168.254.100]

View 48 Replies View Related

SQL 2005, VS 2005: ASPNET Windows Account Not Being Used For Log In

Oct 25, 2006

Ran a trace using profiler and found that the CLR is not using the ASPNET windows account to log into SQL 2005, instead using the admin. Some ado.net code does not work properly as a result. Have had to change the connection string to use SQL logins.Spec: Win XP Pro; IIS 5; 2.0.Is this normal? Where security and permissions are concerned, what changes, if any, are there from SQL 2000? 

View 5 Replies View Related

Backup Fails In Windows Server 2003 For Small Business Server

Apr 23, 2008

Hi

MS Backup in Microsoft windows server 2003 for small business server reports:

<-- Volume shadow copy creation: Attempt 1.
"MSDEWriter" has reported an error 0x800423f4. This is part of System State. The backup cannot continue.

Error returned while creating the volume shadow copy:800423f4
Aborting Backup. -->


The VSS events that I get are 8193 & 6013
The MSSQL$SHAREPOINT events are 17055, 18452 & 18456


These are the main Errors that I get:

Event Type: Error
Event Source: VSS
Event Category: None
Event ID: 8193

Description:
Volume Shadow Copy Service error: Unexpected error calling routine IClientVirtualDevice::GetCommand. hr = 0x80770004.


Event Type: Error
Event Source: MSSQL$SHAREPOINT
Event Category: (2)
Event ID: 17055
User: NT AUTHORITYSYSTEM
Description:
18210 :
BackupVirtualDeviceFile:repareToFreeze: failure on backup device '{74A09E78-8845-47EB-9602-705E4406096C}1'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).



Event Type: Error
Event Source: VSS
Event Category: None
Event ID: 6013
User: N/A
Description:
Sqllib error: OLEDB Error encountered calling ICommandText::Execute. hr = 0x80040e14. SQLSTATE: 42000, Native Error: 3013
Error state: 1, Severity: 16
Source: Microsoft OLE DB Provider for SQL Server
Error message: BACKUP DATABASE is terminating abnormally.



Event Type: Error
Event Source: MSSQL$SHAREPOINT
Event Category: (2)
Event ID: 17055
User: NT AUTHORITYSYSTEM
Description:
18210 :
BackupVirtualDeviceFile:repareToFreeze: failure on backup device '{74A09E78-8845-47EB-9602-705E4406096C}5'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).


I need to get the Backup System working again urgently.
Any advice will be greatly appreciated

View 8 Replies View Related

Load Backup From 2000 To 2005 Or Recreate Structure On 2005?

Apr 23, 2008

Hello,

I would like to ask you if there is better to recreate database structure on 2005 from 2000 and move data or to just load
2000 backup.

Currently I loaded the backup, but I am wondering if there might be slightly better performance on 2005 when recreating structure on 2005 to loading 2000 backup?

Does loading 2000 backup create 2005 binary structure?

Thanks for help in advance

View 5 Replies View Related

Cannot Install SQL Server 2005 On A Windows 2003 Cluster In Virtual Server 2005

Jun 5, 2006

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 3 Replies View Related

SQL Server 2005 On Windows XP Pro

Mar 23, 2006

I'm running on a Windows Xp Pro system and need to install sql server 2005. I will be doing development as well as having the need to use the reporting services. What version of sql server 2005 should I install? I looked for sql server 2005 Developer edition and was unable to find it in the download section from MS.

Any pointers here would be appreciated.

thanks.

View 3 Replies View Related

SQL Server 2005 On Windows CE 5

Feb 8, 2008

Hi all,

I'm having a problem trying to create a SQL server mobile (using SQL Server 2005).
I do the following steps:
I create the database, then I go to Visual Studio 2005 or 2008 (C#) and add this in my application.
Drag and Drop the table to my form I run debug.
I get the error: Impossible to locate PInvoke DLL 'sqlceme30.dll'

I'm using windows Vista, and my pocket PC is Datalogic Memor, with Windows CE 5, Compact Frame Work 2.


Fernando

View 3 Replies View Related

SSCE 2005 + Windows 98

Jun 22, 2007

Does SSCE 2005 work in Windows 98 ??? If yes, How do I deploy my aplication with SSCE 2005 in Windows 98 ???



Thanks every one,

View 3 Replies View Related

XA Connection And SQL 2005 In Windows XP

Nov 14, 2007

I am trying to deploy a J2EE application on WebSphere v6.0 with SQL Server 2005 Developer edition database. I am using windows xp professional Sp2.

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=577185&SiteID=17

In reference to the discussion in the url mentioned above, as Mr.Matt Neerincx was mentioning can anyone update the status of the HotFix?

If the hotfix is available can you please let me know how can I get it.

View 1 Replies View Related

SQL 2005 VB6 WINDOWS VISTA VERY VERY LOW

Aug 8, 2007

I HAVE A PROBLEM
MY PC IS WINDOWS VISTA HOMBRE PREMIUM
2GB RAM
2.7 GHZ
250 HD

I HAVE INTALEDD VB6 AND SQL2005 AND AND HAVE DEVELOMENT ONE APLICATION IN VB6 BUT NO CONCET CONECT VERY LOW, PRESENT ERROR I DONT STAN

AND XP NO PROBLEM PRESENT FUNCIONALIRY IS NORMAL,

View 3 Replies View Related

SQL 2005 Login With Windows Accounts

Dec 19, 2006

Hello,
I'm having a problem using Windows Accounts to login to a SQL 2005 Server.
Here is my setup. The SQL server and web server are separate machines. I'm also not developing directly on the web server.
SQL Server - Windows 2003 Server- SQL 2005- Set to use SQL and Windows AuthenticationWeb Server- Windows 2003 Server- IIS 6.0   - Anonymous Authentication is disabled   - Integrated Windows Authentication is enabledApplication web.config:
<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0"><appSettings>   <add key="ETR_Environment" value="Dev"/></appSettings>
<connectionStrings>   <add connectionString="Data Source=sql-dev-server, 1179;Initial Catalog=ENV_ETR;Integrated Security=SSPI;" name="ETR_Dev"/>   <add connectionString="" name="ETR_Prod"/></connectionStrings>
<system.web>   <compilation debug="true" strict="false" explicit="true"/>   <pages>      <namespaces>         <clear/>         <add namespace="System"/>         <add namespace="System.Collections"/>         <add namespace="System.Collections.Specialized"/>         <add namespace="System.Configuration"/>         <add namespace="System.Text"/>         <add namespace="System.Text.RegularExpressions"/>         <add namespace="System.Web"/>         <add namespace="System.Web.Caching"/>         <add namespace="System.Web.SessionState"/>         <add namespace="System.Web.Security"/>         <add namespace="System.Web.Profile"/>         <add namespace="System.Web.UI"/>         <add namespace="System.Web.UI.WebControls"/>         <add namespace="System.Web.UI.WebControls.WebParts"/>         <add namespace="System.Web.UI.HtmlControls"/>      </namespaces>   </pages>
  <authentication mode="Windows"></authentication>  <customErrors mode="Off"></customErrors>  <authorization>     <allow users="XXXWilliam.Klein"/>     <deny users="*"/>  </authorization></system.web></configuration>
The reason why I want to use the windows login to connect to the database is the application needs to keep track of who did what when entering and updating data but still keep them using there windows login accounts. So using a generic account will not work.
What keeps happening is I keep getting this error: Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. When trying to connect the database. I've tried this on two web servers on another I get something slightly different: Login failed for user 'XXXWeb-Server$'.
Anybody able to give me any suggestions on how to fix this?

View 12 Replies View Related

4 GB Memory For SQL 2005 Std &#043; Windows 2003 Std

Jul 31, 2007

We just upgraded the memory of our database server from 2GB to 4GB. And its OS is windows 2003 standard and sql is 2005 standard edition. According to microsoft(http://msdn2.microsoft.com/en-us/library/ms143685.aspx and http://msdn2.microsoft.com/en-us/library/aa366778.aspx#physical_memory_limits_windows_server_2003), this configuration should allow database use up to 4 GB memory. My question is : Do I need to do anything(such as: adjust the maximum memory in management studio) to let our server be able to consume this extra 2 GB memory?


Does this solution http://support.microsoft.com/kb/274750 apply for SQL server 2005?

View 1 Replies View Related

SQL 2005 On Windows 2000 Server?

Oct 4, 2007

We have a financial software package that has been certified for SQL 2005 and Windows 2003 server. Will SQL 2005 run on a Windows 2000 server? I don’t want to build a new server at this time unless I really have too.

Thanks, Al

View 3 Replies View Related

SSRS 2005 On Windows Vista

Nov 19, 2007

Hello, I am deploying SSRS 2005 on Windows Vista and was wondering if there was a way to automate the following three tasks so that my end-users would not have to do them?



Add a URL to the Trusted Sites for the current computer name?

Change the Security Level setting for User Authentication for the Trusted Site added in step #1 to be automatic logon with current username and password?

Change the properties on IE7 to run with Administrative privileges?
I think, but am not sure that some of these can be done with VBScript? If these can't be automated, then end-users of my application will have to go through these 3 steps manually in order to view the SSRS reports that I have written without being prompted to log in, or encountering error messaged due to insufficient privileges.

Thanks in advance!

Tim

View 5 Replies View Related

Windows Update And SQL Server 2005

Apr 28, 2008

Hello,

I want to actualice my SQL Server and i´m asking if it´s posible to update all the hotfix trough the web update.microsoft.com, there is any automatic way in order to update SQL Server?

If there isn´t, What is the last hostfix?

Thanks

View 1 Replies View Related

MS SQL 2005 + Windows Server 2003 SP2

Jul 13, 2007

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 6 Replies View Related

SQL 2005 Standard Error On Windows XP Pro SP2

Oct 26, 2005

When I run the SQLSTD.EXE for the September CTP of SQL 2005 Std I get the following error message:

View 8 Replies View Related

SQL Server 2005 And Windows 2000

Dec 15, 2006

Hi, Is there any know issues upgrading to SQL Server 2005 on Windows 2000 OS. Any help would be appreciated. Thanks.

View 5 Replies View Related

SQL 2005 &&amp; Windows Password Policy

Mar 13, 2006

We run a few shared hosting servers in the UK, now we used to run mssql 2000 and moved to 2005 in december 2005.

Microsoft SQL 2005                                      9.00.1399.06
Microsoft SQL Server Management Studio      9.00.1399.00
Microsoft Analysis Services Client Tools      2005.090.1399.00
Microsoft Data Access Components (MDAC)      2000.086.1830.00 (srv03_sp1_rtm.050324-1447)
Microsoft MSXML      2.6 3.0 6.0
Microsoft Internet Explorer      6.0.3790.1830
Microsoft .NET Framework      2.0.50727.42
Operating System      5.2.3790

We were in the process of improving security on some of our new servers, in the windows password policies settings we enabled the following
minimum password length = 6 characters
Password must meet complexity requirments = enabled

sql 2005 authentification was set in mixed mode, but we have tried windows authentification only as well.

Now when you try and add a new user even if the password meets all requirments you get an error password is to short etc, we used sql managment studio both manually creating a user and scripting with sql, both with the same result.

In the shared hosting environment we need passwords to be secure, the only way we can get sql users to be created is to disable windows password policies which causes security problems.

We would prefer to use sql authentification not windows but even when we use sql authent it still seems to use the windows password policy and the same error occurs

has anyone else found this problem?

could do with a fix asap!

View 11 Replies View Related

Windows 2003 SP2 Is NOT A Supported OS For SQL 2005 SP2???

Apr 5, 2007

Maybe this is just an oversight in the documentation? Here it is for all to see on the download page for SQL 2005 SP2:

http://tinyurl.com/35nunk

Note the supported operating systems:

Windows 2000 Service Pack 4; Windows Server 2003 Service Pack 1; Windows Vista; Windows XP Service Pack 2

NO mention of Windows 2003 Service Pack 2, but Windows 2003 Service Pack 1 is specifically mentioned.

Any ideas on this one? Thanks!

Chris

View 4 Replies View Related

Windows XP Media And SQL Server 2005

Sep 11, 2006

I'm not finding a definitive answer to my question as to whether or not I can run the development edition of SQL Server 2005 on my brand new pc with this operating system. No one seems to know for sure and I can't afford to pay for tech. support. It should be supported but I don't know where to get a 'real' answer.

thx,

Kat

View 3 Replies View Related

Using SQL Server 2005 DM Add-in Without Windows Authentication

Mar 20, 2007

Hi,

When trying to connect to a SQL Server 2005 Analysis Services instance through the Excel 2007 Add-In, the ability to choose a user name/password combination rather than Windows Authentication seems to be disabled. Is there a way to do this? Thank you!

Melissa Kenny
Harvard Medical School IT

View 7 Replies View Related

Security On SQL Server 2005 And Windows XP

Nov 5, 2006

Dear mems,
I have a problem, and i don't khow how to resolve, pls help me:

My server is Windows XP (not domain),
I work with SQL Server 2005, installed on my server,
I configurate my SQL SERVER connection is "Windows Authentication mode",
I add user "MyComputerguest" to MyServerSecutityLogins to accept connections from local network
I have many databases: Db1, Db2, Db3...

But, I don't know to configurate my SQL Server to achive these:
1) My clients using "SQL Server Managment Studio" connect to Databases Db2, Db3... on my Server, they can expand, modify, add new all Tables, Sp, functions of Db2, Db3.
2) My clients are not allow to access Db1.
2) My clients can add new Databases Db4, Db5, Db6... in the future and they have full permission on every Database which they create without my interfere.

Best regard,

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved