Wondering if there is a different way to setup mail because of Windows Server 2003 instead of Windows Server 2000? The server I'm being asked to get mail working on will have an exchange email account and I'm not familiar with setting this up. On my 2000 machine I had to use Outlook 2000 with option for Corporate or Workgroup an a POP email account. Any help is appreciated.
View 2 RepliesScenario:DBMS: SQL Server 2000OS: Windows Server 2003Goal:Enable SQLMAIL via Internet MailProblem:How do I set up the MAPI profile for the SQL Server service account?On Windows 2000 Server, I can use "Control Panel"/"Mail" tocreate a MAPI profile for the SQL Server service account, and thenreference that profile for SQLMAIL in SQL Server and SQL Server Agent.But on Windows Server 2003, there is no "Mail" applet in "Control Panel".How do I create a MAPI profile, for the SQL Server service account,on Windows Server 2003?
View 5 Replies View RelatedMy uncle runs a small networking company and has extra licenses for Windows 2003 Server as well as SQL Server 2000. Since I just graduated from college and have started working as a database programmer (for a different company) I'd like to setup a small server at home to learn more about SQL (as well as networking, but SQL is my primary concern). I know I can setup SQL Server 2000 on my main PC, but I'd still like to set everything up in a server environment.
So, what I'm wondering is if any books (or web sites?) exist that walk you through setting up Windows 2003 Server and SQL Server 2000. I've actually set these up before (it's not very complicated) but I'm not sure if I did it the "correct" way.
Ideally if any books exist on O'Reilly's Safari Bookshelf that would be even better.
Thanks in advance,
John
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! :(
Hi,
Is it possible to create a new user into Windows 2003 users table (not Sql) through a sql 2005 query ?
I ask this because I forgot the admin password of the Windows 2003 server and this is in a remote location, so I though, since I have the admin password of SQL 2005 server, maybe it could help me to log onto Windows 2003 and reset windows admin password.
Any help would be eternally appreciated
Regards.
George
I have installed a licensed copy of Windows Small Business Server 2003 R2 and was attempting to configure the bundled sql server. The indicator icon in the system tray isn't green (the service hasn't been started). When I right click it and select 'Open SQL Server Service Manager', both Server and Services are blank and the refresh button does nothing. How do I coax this bad boy to start so that I can configure it?
TIA, Jim
Hello, pls Some of my factory guys can log on the same user name at the same time, so I want a situation where a user name may be able to log on, one at a time. Whoever that is reading this, note this is not a misplacement, this is the fact that I don't have means of solving it, I am also of opinion that some have full knowledge of windows 2003 server
View 1 Replies View RelatedI have SQL 2k on a W2003 Server.
I have SP3 installed.
My problem is that i cant connect to the server via telnet:
"C:>telnet localhost 1433
Connecting to localhost...Could not open connection to the host, on port 1433: Connect failed."
I try telnet 127.0.0.1 also.
In the Server Network Utility TCP/IP is ENABLED and the port number is 1433.
Who can help me?
(Sorry for my english)
We have purchased Windows 2003 Small Business Edition Premium.
Our company uses Analysis Manager / Analysis Services and also MDX functions. However Release2 only appears to have SQL 2005 Workgroup edition with it and these features do not seem to be present.
Does anybody know how I upgrade to get these functions? I don’t know if these functions can be downloaded or whether we have to upgrade by purchasing SQL Server Standard 2005 edition outright?
Thanks, Stephen.
Hi,I am unable to connect to a database in my SQL 2000 Server installed ona Windows 2003 Server machine from an asp page. It gives the thefollowing error:Microsoft OLE DB Provider for SQL Server (0x80004005)Login failed for user 'sa'. Reason: Not associated with a trusted SQLServer connection.I also sometimes get:MSDataShape (0x80004005)Data provider could not be initialized.I can connect with the same connection string and parameters from avisual basic 6 application.I can also connect the web client with the same DB in SQL 2000 runningon Windows 2000/XP.The authentication mode is mixed.I believe it is something to do with security. Please advise me on whatto do. It is very urgent.
View 11 Replies View RelatedHi,
I have a client requiring SQL 7.0 installed on Windows 2003 Server Std. Just wondering if its supported and possible to install SQL 97 on Windows 2003 servers.
Thanks
I'm trying to configure SQL server 2000 (standard edition) to send e-mail on a Small Business Server 2003. There's a great article on how to do this on a SBS 2000 server (KB304967), but it does not apply to SBS 2003. Can anyone point me to a article or white paper on how to configure SQL on a SBS 2003 server to send e-mail. Thanks.
David Neahusan
Hello, everyone
I try to set up Sharepoint Portal Server 2003 in SQL Server 2005 database (on Windows 2003 Server R2). But It cannot create new portal site... the Error message told about "cannot access instance..." (in fact that I input the correct instance, user, and password)...??? I wanna know that How to setup it...
Setapong
Hello y'all,
I have to do a new install of SERVER 2000 using WINDOWS 2003 . Has anyone done this. If so, what are the steps. Should I expect any problems ? Any help appreciated.
Thanx
I have been searching the net and haven't found anything that has worked so far for resolving this issue, hopefully someone on here can provide some insight?
I did a fresh install of a Windows 2003 Standard Edition server (as part of a workgroup, not a domain..the server is only temporary for testing) and installed MSDE 2000A (the version that contains all current service packs). I can use the MSDE server locally on the server without any issue...however when I try to connect to MSDE with a workstation, it tells me that Access is denied or the Server does not exist.
The ICF is disabled, and all passowrds being entered have been checked, however I still can not connect to the sql server. Does anyone have any ideas on this or run into this problem before?
Set up - windows server 2003 - SQL server 2000 + tools installed
Not sure why its happening but recently when running some scripts onto one of the databases held on the server windows crashes.
I say crashes - it is non responsive but the mouse cursor can be moved.
these scripts are not being run from the server but from one of many machines on our companies network.
Any suggestions would be great
I have XP workstations and windows 2003 SBS. I setup an ODBC for anapplication (tried both User and System DSN), but after a few usage, I getthe following error:Connection failed:SQLState: 'HY000'SQL Server Error: 0[Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context.Any ideas? Is this a bug?--Thank youPlease post only
View 3 Replies View RelatedI have been searching the net and haven't found anything that hasworked so far for resolving this issue, hopefully someone on here canprovide some insight?I did a fresh install of a Windows 2003 Standard Edition server (aspart of a workgroup, not a domain..the server is only temporary fortesting) and installed MSDE 2000A (the version that contains allcurrent service packs). I can use the MSDE server locally on theserver without any issue...however when I try to connect to MSDE witha workstation, it tells me that Access is denied or the Server doesnot exist.The ICF is disabled, and all passowrds being entered have beenchecked, however I still can not connect to the sql server. Doesanyone have any ideas on this or run into this problem before?
View 1 Replies View RelatedI have a windows server 2003 R2 sharing a filesystem using NFS. I have created a group and passwd file and mapped the ids' to the unix login ids' . I', able to mount but when I try to cd to the directory I get "NFS access failed for server testsrvr: RPC: Authentication error". On the win2k3 server I'm getting an event error "There was a mapping failure". I have the Admin id on the win2k3 server mapped to the unix root login .
View 1 Replies View RelatedAt 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.
I am following the MCTS Self-Paced Training Kit for Exam 70-431 (implementation and maintenance of sql server 2005) and one of the prerequisites is that I have Microsoft Windows Server 2003 running on my computer on an NTFS file system (NTFS) partition. Now am I right in thinking Windows Server 2003 is an operating system. If it is can I install it alongside XP Professional which I am currently running. I am currently afraid to go ahead with the installation as I am worried it will overwrite XP, which would be disastrous as I have a great deal of data on it.
Thanks
vik
I have a problem i have been working on moving sql2000 databases to 2005.
I have two servers running on one machine.
Is there a way to make my 2005 server a default server
I want to make 2005 a default server instead of 2000.
Because in my connection string from the applications i connect to server using external ip & it's connecting to 2000 instead of 2005.
How can i solve this problem
let me know
thanks
I have SQL Server 2000 running on Windows 2003 Server. I have Windows 2000 Server running IIS. I am trying to connect my asp running on 2000 to my SQL Server running on 2003, but I run into the problem when I have to machines connecting to the database. The first machine works, but the second machine comes up with the page is not found. When the first machine is done with getting the data, I am able to refresh on the second machine and it works. Some reason it is only allowing one connection at a time on the same database. Any help would be greatly appreciated. Thanks
View 2 Replies View RelatedI tried installing SQL Mail but it didnt work.
What happened was, when I was entering the SQLMail profile for an Exchange User name. It took those values. Now when we ran/initialize SQLMail service, the Cluster Services kept rebooting/re-initializing all the services. Therefore, system crash and will not provide any services any longer.
We tried resolving it by running the SQL services in node 2 and we got MSSQLServer v6.5 service running but the SQLExecutive service
will not start.
I tried to reset the permissions on the services and have
that SQLExecutive run on the NT Administrator account.
After reading a few technotes from MS and applying them.
None seem to have worked so far. Here are some of the technotes:
Q195761
Q158585
Q155697
Q155283
(1) How can we fix the SQLExecutive so it will autostart with bringing down the cluster
(2) What can we do to successfully run SQL mail on the cluster server with this all the variables in this situation.
I am going to start installing sql server soon, do I have to have IIS installed? Is it a requirement?
Thanks.
anyone has tried? please advice possible issues, workarounds
tks
Hi,
I've noticed declining performance on our main accounting server. We have a Windows 2003 server running SQL 2000 Enterprise and 8 GBs of RAM.
Has anyone used the "boost SQL Server priority on windows" before? If so, were there any major benefits in using it?
This server is excusively used for SQL btw...
Thanks,
DJ
Hi all,
I have SQL server 2005 enterprise edition on windows server 2003 machine. when i took the back of the database from this sytem and try to restore the backup on SQL server 2005 R2 enterprise edition on client machine. it is giving me following error
"
Restore failed for Server '10.112.12.229'. (Microsoft.SqlServer.Smo)
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFX_Global_backup_200805141500.mdf'. (Microsoft.SqlServer.Smo)
"
Please tell what is the error about?
Can it be possible to restore a back up of different operating system machine to other ?
Hi there,
We've got a Windows 2003 (64 bit edition) box to use as our Database server.
I installed SQL Server 2005 (Standard Edition) on the machine, but I have a feeling it has installed the 32 bit version and not the 64 bit version.
The reason I think this is that the MSSQL directory is under the 32 bit program files directory and not the 64 bit directory, and also when I look at the service properties it says it's running from WOW6432 registry entry.
Is there a separate disc for the 64bit version? Does the installer automatically work out which version to install or is there some sort of switch I have to do to tell it to install the 64 bit version.
Many thanks for your time.
Simon
Hi,I tried to Develop one Report in SQL Reporting Service. I haveinstalled SQL Reporting Serivice in Windows 2003 machine. SQL ServerDatabase is in another machine, running on Windows 2000. I developedand deployed the report and all went fine.When I tried to see the report through the Report Service Manager WebPage it is comming properly. But When I tried to See the report inanother web page, I'm not able to see the images. But the Data isgetting Displayed and only Image is not comming. When I exported thereport to Excel, the Image is comming over there.I am using Report Viewer control (Which came as Sample Program) inthe ASPX Page to render the report. I'm using SQL Server 2000 with SP3aand SQL Server 2000 reporting Service with SP1.I tried setting the Mime Time for the GIF image and even "*.*" inthe Mime Type settings of IIS 6.0. Even then its not displaying theimage.Can any one help me out in solving the problem?Thanks in Advance.With RegdsKrish
View 1 Replies View RelatedDoes SQL Server 2000 CE 2.0 work on Windows Mobile 2003?
Thank you,
Ken Carlino
ServiceMaster
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?
Hello there,
We got SQL Server 2000 Standard Edition SP3 running on Windows 2003 server.
Now, we would like to apply windows 2003 SP1 to the Operating System.
We are concerned that whether windows 2003 SP1 is compatible with SQL server 2000 (SP3)?
I was looking at the application comaptibility chart for Windows 2003 SP1.Among them SQL Server 2000 Enterprise Edition Service Pack 3a was listed but not the Standard Edition.
My Question - Is windows 2003 server SP1 is compatible with SQL Server 2000 (SP3)?
Thanks