|
I'm trying to replicate a database from SQL Server 2005 to SQL Server 2000, while creating a new Subscription when I try to add a subscriber server the following error message is displayed.
TITLE: Connect to Server
ADDITIONAL INFORMATION:
Failed to connect to server BERN. (Microsoft.SqlServer.ConnectionInfo)
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) (Microsoft SQL Server, Error: 53)
I did Googleing but I could not find a suitable solution, please help me out. I will be grateful to you.
Sami.
|
|
|
|
|
Are you able to connect to the remote server using management studio? (by openning a new database query window)
|
|
|
|
|
Hi,
My backend is MSAccess. I have a table which contains a field 'return date' which is DateTime. I want to subtract the return date from the current date in the query.This should be done only between dates and not time.
|
|
|
|
|
Hi,
You can do this in the following manner.
---------------------------------------------------------------------------
BEGIN CODE
Dim d1, d2 As Date
Dim diff As Long
d1 = Date.Parse(CurrentDate)
d2 = Date.Parse(ReturnDate.Text)
diff = DateDiff(DateInterval.Day, d1, d2)
END CODE
---------------------------------------------------------------------------
This code will return the days only.
I hope this helps  .
Regards,
John Adams
ComponentOne LLC
|
|
|
|
|
i google the net but i did't fined any simple project about how to save an image in sql 2000 using C# language.
Plz just how can i comver the image file to byte string.
Help me out just put a link or small chunk of code. 
|
|
|
|
|
Naveed khan nido wrote: i google the net but i did't fined any simple project about how to save an image in sql 2000 using C# language.
I also did a search and found the following results[^] in about 5 seconds.
What were you searching for?
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Actually i got the results but that are difficult in sql, i just want to save only pic not much information about it.
I just need simple code.
|
|
|
|
|
Naveed khan nido wrote: I just need simple code.
One of the skills a developer needs to possess is the ability to undertake research to find the solution to a problem. It is unlikely that you will succeed in your chosen career if you ask people to do your work for you, despite having been given advice and pointed towards sample code.
Read the articles I suggested again, attempt to solve the problem yourself using the samples provided and post again if you have any further questions. If you want someone to do your work for you, I'm afraid you've come to the wrong place.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
|
hi there,
i want to set password on my database of SQL server 2005, can someone tell how can i do this?
thanks
Becoming Programmer...
|
|
|
|
|
xmen wrote: i want to set password on my database of SQL server 2005, can someone tell how can i do this?
You don't set a password on the database itself. You set a password for a user account that can access the database. If you create a new user account from SQL Server Management Studio, you will be prompted to select the method of authentication this account will use (Windows/SQL). If you select SQL authentication, you can define a password for the account. User accounts can also be created from T-SQL, but I don't know the syntax of the top of my head. Search the MSDN documentation if you want to know more.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Actually, it is a two stage process and it isn't a "user account" exactly. You first of all set a login on the server. You then go around each database that login is to have access to and create a user for the database and associate it with the login.
|
|
|
|
|
Oh yes I remember that on our servers - thats the 'sa' login with a password of 'administrator' 
You always pass failure on the way to success.
|
|
|
|
|
I was aware of this. Admittedly however, my explanation could have been better.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
yeah, i tried, i created an account but it didnt work.
steps i did.
1. conect sql MS with windows authentication
2. Security > Logins > New
enter login name
select SQL Server authentication
enter password
3. uncheck "User must change password at next time"
4. select default database
5. checked all server roles
6. checked all Role membership of my database in user mapping
7. press "OK" and done and close sql MS
8. open sql MS, select SQL Server authentication
9. enter login name and passsword
and it gave error :
TITLE: Connect to Database Engine
------------------------------
Cannot connect to MATO.
------------------------------
ADDITIONAL INFORMATION:
Login failed for user 'MYLOGINNAME'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18452&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
any idea?
Becoming Programmer...
modified on Sunday, January 13, 2008 11:27:53 PM
|
|
|
|
|
I'm not sure. Did you definitely grant permission for your SQL login to access your MATO database?
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
i only grant permission from properties of login, i dunno more than it, if you know please tell.
thanks
Becoming Programmer...
|
|
|
|
|
yehe...!! i successfully created an account but the database i wanna lock, can be open by windows authentication
how can i restrict that no user can open this database?
Becoming Programmer...
|
|
|
|
|
xmen wrote: how can i restrict that no user can open this database?
Don't grant any logins access to the database.
Why would you want to do this though? If no users can access your database, what purpose does it serve?
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
no no i didnt mean that, i want that my database should open only with my id, i wanna set password on database as written in the title
Becoming Programmer...
|
|
|
|
|
xmen wrote: i want that my database should open only with my id, i wanna set password on database as written in the title
Well, if you are running the process that is accessing the database then you can open a connection becuase you are already authenticated against the process that is calling the database. However, another user cannot because the database should only be accepting connections from Windows applications running in your account.
Windows Authentication says that the user does not need to log in AGAIN, because they are already logged into the computer (or have started the process with Run As... and logged into the process as a different user that has access)
|
|
|
|
|
no no, my problem is something like this that e.g. i've an application that attached to database, database contains lots of important information, i want to give this app to my friend and dont want that any stranger can get those important info by using SQL MS, my app is secured with password, but the sql database isnt, thats why i'm trying to set password on database but i got to know that this isnt possible,
so please tell me a good way to solve this problem
Becoming Programmer...
|
|
|
|
|
xmen wrote: my app is secured with password, but the sql database isnt, thats why i'm trying to set password on database but i got to know that this isnt possible,
Yes, your database IS secured by a password somewhere. (We are talking about Microsoft SQL Server 2000/2005/2008)
Either your app is passing the user id/password in the connection string. Or it is using a Trusted Connection (in which case the user/password used is the one the user used when logging into windows - If the user can log into their windows account without a password that is not the fault of the database as it has been told to trust the windows account)
|
|
|
|
|
Colin Angus Mackay wrote: If the user can log into their windows account without a password that is not the fault of the database as it has been told to trust the windows account
so how can i say that my database is secured...
Becoming Programmer...
modified on Monday, January 14, 2008 1:19:30 PM
|
|
|
|
|
xmen wrote: so how can i say that my database is secured
If YOU don't trust the windows account, don't tell SQL Server to trust the windows account. In other words, don't give it logins that tie up to windows accounts that don't have passwords.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
