|
Do you have multiple sql servers running on that server?
Ben
|
|
|
|
|
hi ben
there r only single instance.
thanks
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
|
|
|
|
|
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
|
|
|
|
|
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)
|
|
|
|
|
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
|
|
|
|
|
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)
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
|
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!
|
|
|
|
|
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
|
|
|
|
|
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 )
|
|
|
|
|
I've answered this question several times now: previous answer[^]
Why won't you accept the answer you were given?
|
|
|
|
|
Wow - we seem to have a flood of people who ask the same question over and over.
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 )
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
It is not possible. Either set a single sql server user and password in the connection string. Or use Windows authenticated users for your sql access.
Ben
|
|
|
|
|
ok then I'd rather go with the conventional user tables
thanks
|
|
|
|
|
Hi every one,
Well I’m building a desktop application for an organization in C# 2.0 and Sql Server 2000 and I was wondering abt putting some sort of restriction so that the user doesn’t access the data in the tables from the Enterprise Manager. So first, plz tell me if this is a good idea or not. Well I think at least some users should not be able to access the tables directly. So how can we put this restriction?
Thanks in advance,
Rocky
|
|
|
|
|
User accounts. Each user connected with the relevant username and password, or via windows authentication (which logs them in with their windows account). You can restrict access based on the account or role.
|
|
|
|
|
Hello everyone,
I’m working on Fuzzy lookup within SSIS package. It is done with the fixed similariry and looking up fields. Right now, we are trying to move to use dynamic varibles for Similarity and looking up fields. That means the similarity value and looking up field values are passed by variables and are assigned values from outside of the ssis package. If anyone has an idea on how to do it, could you please give me a clue. I’m really apprecite your any suggestion in advance.
|
|
|
|
|
Hello,
I am in search of the .NET Framework 1.x and 2.0 and 3.0 class
library maps and ADO.NET class library maps to hang/pin to my cube at
work and also at home. I believe that helps understand more about the
Framework and ADO.NET objects and class libraries. Also if some thing
is presented in a pictorial (grapihical) representation I guess I can
learn more than reading whole lot of stuff.
So is there a place on the net or any company that offers this kind of
to buy or down load?
Any inputs or help me finding on this is greately appreciated.
Thanks in advance,
-L
|
|
|
|
|
Hi,
can enybody know, if possible encode all database?
Problem is that, I have database and application, which are offer to user. And I don't want user could to browse database without using application.
thank for every suggestion
Pavel
|
|
|
|
|
I would think it would make more sense to only give access to the application to access the sql database and remove all other access. So if you application is using a sqluser name and password for its connection. Only give that user access.
If that is not an option. Then another possibility is to make sure all of your database access for you application happens through stored procedures. In which case the user would not need select access to any of the tables only execute rights on the stored procedures.
Hope that helps.
Ben
|
|
|
|