|
|
I have installed visual studio 2008. Then I installed sqlserver management studio. I connect using windows authentication. But there is another option to connect using sqlserver authentication. Where will I get the login name and password to connect using sqlserver authentication.
For test purpose I have connected using windowsauthentication and then created a login by right clicking the security folder and I have chosen sqlserver authentication and provided necessary information and clicked ok.
But when I tried to login by this new login name using sqlserver authentication It shows the following error:
"A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)"
Am I in the right way to login using sqlserver authentication? If I am in right way why I am getting the error?? Please help to solve the problem. I really need to test the option: sqlserver authentication
|
|
|
|
|
1. Check that mixed mode authentication is enabled.
2. Check that the "sa" login is enabled; I think it's disabled by default.
|
|
|
|
|
I have enabled the sa login. But how can I enable mixed mode?
|
|
|
|
|
You can enable mix mode Authentication via connecting to SQL Server in Mamagement Studio via Windows Authentication then Open the Properties of the Server. Select Security Page listed in left panel.
At this page, there is Server Authentication Block, Choose SQL Server & Window Authentication Mode.
I hope it gonna help u.
|
|
|
|
|
Thanks a lotzz!!! It's really great. It is working.... 
|
|
|
|
|
|
Unfortunately the server doesn't allow ftp for security so I can't backup the database and then send it through ftp to the other server.
So is there anyway I can do this from sql server 2008?
Is there a way to write the url or path of the remote server in order to save the backup file?
example: \\1.2.3.4\.... something like that?
|
|
|
|
|
Backups are done Locally. That is why when you try to make a Backup, it only gives you a Local Filesystem option. So what you can do is that back them localy and move them Programatially.
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
Thanks for the reply.
Do you mean create something like a windows service to move the backuup file to another server? How can I do that if ftp is disabled on the server?
|
|
|
|
|
If you cant have Access to the FTP , you can share the Folder in the Destination Folder and Map it in the Machine that does the Backups. and move the backups Between these Folder. You can Add this as a Batch File and that Batch File gets Executed as a Job in SQL After the Backups are done.
Hope this Helps
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
I'm sorry for bothering you, but my problem is that the 2 server are on different networks.
So I don't know how to share folders between them.
Can you help out by explaining with an example?
|
|
|
|
|
You are not Bothering me. its my pleasure to help.
Can you Ping the Other Machine, meaning can you Ping from the computer that does the backups ?
Go to Run-->cmd
in the Command type
Ping <<IP or Computername>>
and see if there is a reply and post back the results here
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
modified on Tuesday, September 29, 2009 8:20 AM
|
|
|
|
|
I pinged the other server successfully from the server that does the backups.
|
|
|
|
|
Good, Go to your "My Computer" --> when you are there
Click on Tools-->Map Network Drive and Write the Following in the Folder Option
\\ComputerName\ShareName\
Remember the ShareName needs to be the name of the Share in the other Computer. So that means you need to go to the other Server and Create a Folder and Share it. The name of the Folder will be the name of the share. and Write a Small Program that will move the Files across
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
|
First Question. Do you automate your Backups to Happen at a Specific Time ?
The Next thing you need to do is to text if you can place any File in the Share. Just Copy any File and paste it in your Share. if you have no Permission Problems then its Cool. Create a New Project create a cmd Project
and Look at this Articles to Create a cmd application to Copy Files
http://msdn.microsoft.com/en-us/library/cc148994.aspx[^]
http://msdn.microsoft.com/en-us/library/system.io.file.copy%28VS.71%29.aspx[^]
http://www.dreamincode.net/code/snippet1807.htm[^]
http://www.computerhope.com/issues/ch000766.htm[^]
When you are Done , Create a Batch File and Tell it Execute this File, to Create a Batch File and Run the Batch File on the time you know your Backups will be Done. I was gonna say you must use Jobs in SQL, am not Sure if you know them .
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
thanks a lot for your help, I'll take a look at them.
Just one more question regarding sql server 2008.
If I want to access a sql server 2008 database remotely from a computer that resides on a different network, should I use SQL server management studio 2008 or can I just use sql server SQL management studio 2005?
I've been having a hard time connecting to the database remotely. I enabled remote connections and I added some rules to the firewall to open sql server ports but to no avail. I've done everything that could allow remote connection but failed to connect to it and when I telnet the server with its port number, the connections fails too.
Is it possible that maybe the network that the server belongs is blocking remote connections??
Any opinions are welcome?
Thanks in advance for all ur help
|
|
|
|
|
Well most of the Time i access SQL Servers within the same Network, or i remote Desktop. I suggest you look at you Antivirus. Turn it off and see if you can connect, if you can then consider add an Exeption for that Connection in your AV. Again the Errors you get when trying to connect to a Remote SQl Server might lead to a Solution. am not sure what Type of Errors you are Getting.
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
Here's the error I get
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: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) (.Net SqlClient Data Provider)
I'll check the antivirus.
Thanks a lot.
|
|
|
|
|
|
yes, I know, I've searched these pages but still no access.
I will try the antivirus thing and see if I can access it.
Also I think it's the network that has a problem.
Thanks a lot for all ur help.
|
|
|
|
|
You are Welcome
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
Vuyiswa Maseko wrote: C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/IGI/itsabacus/
need more information about it if possible.
|
|
|
|
|
Which info do you need ?
Vuyiswa Maseko,
Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vimalsoft.com
vuyiswa[at]vimalsoft.com
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
(yikes why didnt I think of this) 