Discussion on:
View:
Show:
0
Votes
this article is not good please clear full contant send me
This is a fantastic step by step guide. You even mentioned, as a final note, about the errors on native client, which helped me. Thank you
Joseph
Joseph
0
Votes
Hi,
I am an Oracle DBA, and am planning to learn DBA skills for Microsoft SQL Server 2005.
I want to install "SQL Server 2005 Express Edition", because it is free; do you know if it is sufficient enough to do HANDS-ON-TRAINING, to learn DBA skills?
I would appreciate your insight.
Thank You!
I am an Oracle DBA, and am planning to learn DBA skills for Microsoft SQL Server 2005.
I want to install "SQL Server 2005 Express Edition", because it is free; do you know if it is sufficient enough to do HANDS-ON-TRAINING, to learn DBA skills?
I would appreciate your insight.
Thank You!
0
Votes
When we install sql server 2005 Express Edition, the authentication should be Sql server not window authentication. how we can change to sql server
Hi,
It's very simple.
During the Security Dialog of the installation, choose Mixed Authentication Mode and enter a STRONG SA PWD.
or after installation perform the steps outlined below.
Launch SQL Server Management Studio Express and login using windows authentication.
Now right click on your server instance and under the Security properties choose SQL Server and Windows Mode.
Now Restart the instance, you can now login using your SA Login
Final note:
Always try to use Windows Authentication as it is considered a best practice.
Kind Regards
Anil Mahadev
Senior SQL Server DBA
http://anilm001.myfreewebs.net
It's very simple.
During the Security Dialog of the installation, choose Mixed Authentication Mode and enter a STRONG SA PWD.
or after installation perform the steps outlined below.
Launch SQL Server Management Studio Express and login using windows authentication.
Now right click on your server instance and under the Security properties choose SQL Server and Windows Mode.
Now Restart the instance, you can now login using your SA Login
Final note:
Always try to use Windows Authentication as it is considered a best practice.
Kind Regards
Anil Mahadev
Senior SQL Server DBA
http://anilm001.myfreewebs.net
I have successfully installed SQL Express. Now I want to add SMS functionality to it. Do you know any tool, that can do this free of charge? The one I found at http://www.ozekisms.com/ seems to do the job, but it quite expensive.
0
Votes
very helpful for new one's.thanks a lotttt.bye
Hello Friends,
I have just created the Instance named the SAPDB and its completely working with the Windows Authentication with Local 'Administrator' User, and when i used to login with the SQL Server Authentication with 'sa' User then its giving me error like "Login failed for user 'sa'. (Microsoft SQL Server, Error: 18456)'
Please help me to solve out.
thanks & regards
hardik
I have just created the Instance named the SAPDB and its completely working with the Windows Authentication with Local 'Administrator' User, and when i used to login with the SQL Server Authentication with 'sa' User then its giving me error like "Login failed for user 'sa'. (Microsoft SQL Server, Error: 18456)'
Please help me to solve out.
thanks & regards
hardik
Hi Hardik,
Its very simple,
Launch SQL Server Management Studio Express and login using windows authentication.
Now right click on your server instance and under the Security properties choose SQL Server and Windows Mode.
Now Restart the instance, you can now login using your SA Login
Final note:
Always try to use Windows Authentication as it is considered a best practice.
Kind Regards
Anil Mahadev
Senior SQL Server DBA
http://anilm001.myfreewebs.net
Its very simple,
Launch SQL Server Management Studio Express and login using windows authentication.
Now right click on your server instance and under the Security properties choose SQL Server and Windows Mode.
Now Restart the instance, you can now login using your SA Login
Final note:
Always try to use Windows Authentication as it is considered a best practice.
Kind Regards
Anil Mahadev
Senior SQL Server DBA
http://anilm001.myfreewebs.net
0
Votes
Hi,
I have online server with Valid IP address and I have installed SQL 2000 enterprise with SP4 and Installed SQL 2005 enterprise edition, with different instance name , on windows 2003 Standard with SP2.
Now tow sql server up and running but I have a problem:
I can connect to SQL2000 database's from remote client but I can't connect to SQL 2005 from remote clients, what should I do to can connect to SQL2000 and 2005 from remote client?
Thanks
I have online server with Valid IP address and I have installed SQL 2000 enterprise with SP4 and Installed SQL 2005 enterprise edition, with different instance name , on windows 2003 Standard with SP2.
Now tow sql server up and running but I have a problem:
I can connect to SQL2000 database's from remote client but I can't connect to SQL 2005 from remote clients, what should I do to can connect to SQL2000 and 2005 from remote client?
Thanks
0
Votes
My sql installer CD is giving error when installing on INTEGRATED SERVICE, when i abort the installation it continues installing all other components except Int. Ser. What i have to do for this, is this tie the CD Problem? Please help.........
0
Votes
GREAT WORK MAN THANK YOU SO MUCH
0
Votes
thanks this helped me a lot installing MS server 2005
0
Votes
how do i install sql server 2005 on server side can any one help
I developed a program in Visual c# using sql server 2005 express edition as database.Now I want use this program in a different machine.How do connect with database file. Please help
0
Votes
You're the man!! Thank you
0
Votes
What an insane **** up!!!
After all was done, and SQL Express rebooted the machine,...The machine would'nt get past the Login stage, black screen, so we get the Xp Disc out, reboot and "R" to repair and now it goes into perpetual boot and reboot.
MS and SQl Express (the SP3 for Xp Home)(wish they read this) are absolutely ******* useless.. Consider how many posts are out there re installing IIS on XP Home and the woes and other issues.
Theres a banana republic company alive and well in the USA.
Am I pissed,...? The entire business , our livelihood resides on that machine. Emails, Docs, Forms, clients, payments etc and no way to get to them now.
Not that MS would give a ****.
bunch of dooses (means in English) "Criminally Stupid Vaginas"
After all was done, and SQL Express rebooted the machine,...The machine would'nt get past the Login stage, black screen, so we get the Xp Disc out, reboot and "R" to repair and now it goes into perpetual boot and reboot.
MS and SQl Express (the SP3 for Xp Home)(wish they read this) are absolutely ******* useless.. Consider how many posts are out there re installing IIS on XP Home and the woes and other issues.
Theres a banana republic company alive and well in the USA.
Am I pissed,...? The entire business , our livelihood resides on that machine. Emails, Docs, Forms, clients, payments etc and no way to get to them now.
Not that MS would give a ****.
bunch of dooses (means in English) "Criminally Stupid Vaginas"
I am unable to install Windows Vista Home Premium edition.
Windows Vista supports SQL Server 2005 or not.
Plz, reply.
Windows Vista supports SQL Server 2005 or not.
Plz, reply.
0
Votes
SQL Server Database Service interrompido com SSL n?o COnfi?vel?????????????
0
Votes
thanks, this is useful for me to try my labs ,it's like an example for me!
You might not have windows sp3 installed in your computer.
http://www.soft32.com/download_123572.html
http://www.soft32.com/download_123572.html
dear sir there is third party component not supported or otherwise some oparating system file currepted or not supported file system check wether it having problems
why it's always error every time i tried to download the SQL
server?
server?
hello sir you need to purchage a licence copy and all installation ,configuration detailes in that make sure you purchease before wich version would you like to intsall
thanks and regards
mehboob
thanks and regards
mehboob
realy thanku you techrepublic this site very helpfull for user and admin s
post some all 2008 server all configaration
regards
tech team
post some all 2008 server all configaration
regards
tech team
- Keyboard Shortcuts:
- Prev
- Next
- Toggle

































