Database

30-Apr-07 20:43

hi ben,

according to ur specification, i remove the server name from my connection string. but now this time, i face new error which is following

when i use following SQLConnection string (vb.net)

SqlConn = " Data source=xx.xx.xx.xx; Network Library=DBMSSOCN; Initial catalog=DatabaseName;uid=user ID;pwd=Password;"

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 socket operation was attempted to an unreachable host.)

when i use following SQLConnection string (vb.net)

SqlConn = " Data source=http://xx.xx.xx.xx; Network Library=DBMSSOCN; Initial catalog=DatabaseName;uid=user ID;pwd=Password;"

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 - No such host is known.)

and when i use oledbconnection string (vb.net)

oledbConn = "provider=SQLOLEDB; Data source=xx.xx.xx.xx; Network Library=DBMSSOCN; Initial catalog=DatabaseName;uid=user ID;pwd=Password;"

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

and when i use oledbconnection string (vb.net)

oledbConn = "provider=SQLOLEDB; Data source=http://xx.xx.xx.xx; Network Library=DBMSSOCN; Initial catalog=DatabaseName;uid=user ID;pwd=Password;"

[DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not found.

operating system-XP sp2

Thanks

Rupesh Kumar Swami

-- modified at 7:29 Tuesday 1st May, 2007

kubben1-May-07 3:35

1-May-07 3:35

Can you ping the ip address?

Ben

Rupesh Kumar Swami1-May-07 3:54

1-May-07 3:54

hi ben,

i can ping the IP address

i don't understand what is the problem ?

thanks

Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)

kubben1-May-07 4:11

1-May-07 4:11

Do you have multiple sql servers running on that server?

Ben

Rupesh Kumar Swami1-May-07 4:20

1-May-07 4:20

hi ben
there r only single instance.

thanks

Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)

kubben1-May-07 4:27

1-May-07 4:27

Can you successfully create an odbc connection to it?
Go to Control Panel -> Administrative tools -> Data sources (ODBC)
Click the add button. Then scroll down to the sql server and click finish.
Next type in the server name, click next and select sql authentication. Put in your username and password. click next. If you get an error, you have a problem with your user name and password perhaps. If you get to the next screen select your database. If you don't see your database in the drop down your user doesn't have rights to that database. If you get to the next screen you should be able to test the connection. If the test works then you should be able to use the same server, database, user and password to make your connection work in your program.

Hope that helps.
Ben

Rupesh Kumar Swami1-May-07 5:01

1-May-07 5:01

hi ben ,
according to your specification i follow steps as following

pressing finish button after selecting Sqlsever from datasource list ,there r new window appear. I type ip address of remote server(in textbox related to server) and click next. after that i select SQL Server authentication and put username & password and clicking on next button give error.

here i m sure that user name & password is correct.

any idea where i m wrong.Thanks

Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)

kubben1-May-07 5:03

1-May-07 5:03

If you can't create an odbc connection, something is wrong. Try using the sql server name. there must be some issue with the name / ip of the sql server and the username and password. Once you can get it working with an odbc connection you can use the same values to get it working in your app.

Ben

Rupesh Kumar Swami1-May-07 5:18

1-May-07 5:18

hi ben ,
i also try with ip address & server name (not only with server name) but problem not solved.
if u have any other idea ,please inform me
Thanks for your support.

Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)

kubben1-May-07 5:42

Security in Sql Server2000

1-May-07 5:42

I guess you could try using the query sql tool to connect to the sql server with that user name and password, but I am pretty sure you will get the same results. For some reason your sql server name or IP or username/password is not correct. Until you figure that out you will not be able to connect.

Ben

Security Information

Brady Kelly27-Apr-07 23:36

Brady Kelly

27-Apr-07 23:36

Please will someone recommend some good, detailed resources on SQL Server 2005 security. I am going to select and purchase a book on the subject next week, on which I would also appreciate recommendations, but I need to achieve some tasks in the mean time, so I would like some on-line resources I can read now.

I would like to learn more about asynchronous keys and associated logins, how to grant unsafe assembly permission to a database owner[1], more about 'alias' users such as 'dbo', the relationship between the machine administrator group and SQL server, owner ship or rights over schemas vs actual objects etc. and even basic secutiry such as logins vs. users.

Re: Security Information

Lojne28-Apr-07 10:32

Lojne

28-Apr-07 10:32

I don't know books about SQL Security, however i know some sites that talk about SQL Injection, which can be very very destructive.
Links, you will need to search into the blogs the related topics to SQL Injection:
FR3DC3RV BLOG
RONALD BLOG
Good luck Smile | :)

Re: Security Information

Jerry Hammond28-Apr-07 10:40

Jerry Hammond

28-Apr-07 10:40

SQL Server Security Crib Sheet[^]

Learning is not a spectator sport. - D. Blocher

OLE DB Notification

x_yan_y27-Apr-07 22:16

x_yan_y

27-Apr-07 22:16

Hello everyone:
i write a win32 c++ program,then i add ATL OLE DB consumer in my project.now i need the function that when the SQL database's data change,my main program's window can refresh view.so i refer to msnd:
==========================================================================
Visual C++
Receiving Notifications

OLE DB provides interfaces for receiving notifications when events occur. These are described in OLE DB Object Notifications in the OLE DB Programmer's Reference. Setup of these events uses the standard COM connection-point mechanism. For example, an ATL object that wants to retrieve events through IRowsetNotify implements the IRowsetNotify interface by adding IRowsetNotify to the class-derived list and exposing it through a COM_INTERFACE_ENTRY macro.

IRowsetNotify has three methods, which can be called at various times. If you want to respond to only one of these methods, you can use the IRowsetNotifyImpl class, which returns E_NOTIMPL for the methods you are not interested in.

When you create the rowset, you must tell the provider that you want the returned rowset object to support IConnectionPointContainer, which is needed to set up the notification.

The following code shows how to open the rowset from an ATL object and use the AtlAdvise function to set up the notification sink. AtlAdvise returns a cookie that is used when you call AtlUnadvise.
---------------------------------------------------
CDBPropSet propset(DBPROPSET_ROWSET);
propset.AddProperty(DBPROP_IConnectionPointContainer, true);

product.Open(session, _T("Products"), &propset);

AtlAdvise(product.m_spRowset, GetUnknown(), IID_IRowsetNotify, &m_dwCookie);
============================================================================
the code is so little that i don't know how to implement in my code,did anyone can help me?
thanks a lot!

.NET- India 27-Apr-07 19:27

.NET- India

27-Apr-07 19:27

Hi All,
How can i make my database more and more secure so that unautorised user cannot have access to my database by Enterprises Manager
If they are unauthorised then Enterprise Manager won't let them in.

Thanxxxxxxxxxxxxxxx

Re: Security in Sql Server2000

Christian Graus27-Apr-07 20:15

Christian Graus

27-Apr-07 20:15

If they have the admin password, and access to your network, then there's not anything you can hope to do. Your DB is as secure as your network, no more, no less.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: Security in Sql Server2000

Colin Angus Mackay27-Apr-07 22:55

Colin Angus Mackay

27-Apr-07 22:55

I've answered this question several times now: previous answer[^]

Why won't you accept the answer you were given?

Upcoming events:
* Glasgow: Introduction to AJAX (2nd May), SQL Server 2005 - XML and XML Query Plans, Mock Objects, SQL Server Reporting Services...

Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton

My website

Re: Security in Sql Server2000

Christian Graus27-Apr-07 23:52

Christian Graus

27-Apr-07 23:52

Wow - we seem to have a flood of people who ask the same question over and over.

Cannot find the certificate

reykentj27-Apr-07 12:37

reykentj

27-Apr-07 12:37

Cannot find the certificate 'AccountingCorp', because it does not exist or you do not have permission
here is the sql
USE master
CREATE LOGIN Dave
FROM certificate AccountingCorp;
GO

I created the certificate with this code.
USE Frontier_equipment;
CREATE CERTIFICATE AccountingCorp
WITH SUBJECT = 'Frontier Accounting Records',
EXPIRY_DATE = '10/31/2009';
GO

rkj

Using SQL Server logins to login from an Application

Rocky#27-Apr-07 10:45

Rocky#

27-Apr-07 10:45

hi again,
I wanted to ask is that I want the users created in my SQL server database to be the one’s used to login to my application as well. As all of us know, generally we create a users Table in the database and use this table to allocate Login ID’s to the employees but I want them to be the users of SQL server db as well so that I can also enable appropriate restrictions on a particular user type. So how can we do that? I know how to create a user in SQL Server but I don’t know how to access the ID and password. What’s the data Dictionary table that holds this information?

Rocky

Re: Using SQL Server logins to login from an Application

kubben27-Apr-07 11:48