Database

Re: How can i Do this work Programmatically for SQL EXPRESS 2005

5-Aug-08 7:20

hi all,
I want to do following task as programmaticaly (not manually) to Allow Remote Connection
1.Enable the Shared memory, Named Pipes, TCP/IP protocols in SQL Server Configuration.
2.Allow Local And Remote connection which we perform IN SQL Surface area configuration.
3.Restart SQL Browser and SQL Server After making changes.
4.Create Login on Remote SQL Server

I face above problem when i Installed SQL Express on one machine and Try to connect to Remote SQL Server. Also if I want to Connect to Remote server, then Guest Account(or SQL Authentication) must be Configured on Remote machine. So how can i Configure the Account on remote server Programmatically or how can i Get the Configured account which is on Remote server . so using this account information i can connect to Remote SQLServer.

one more thing I am able connect to Remote server using trusted connection but failed to connect to Database. I use Following statement to connect to Remote SQL Server

Dim MainServer As Server = New Server(cboServer.Text.Trim & "\SQLEXPRESS")<br />
        With MainServer.ConnectionContext<br />
            .LoginSecure = True<br />
            .ConnectionString = "Trusted_Connection=Yes;"<br />
            .Connect()<br />
            .PublicServerName = cboServer.Text.Trim<br />
            frmLogin.Show()<br />
            Me.Close()<br />
            .Disconnect()<br />
        End With

but i am unable to Use Databse which reside on Remote server. I use following connection string

Dim ConnectionString As String = "Data Source=" & PublicServerName & "\SQLEXPRESS;Integrated Security=True;Initial Catalog=ABC "

Dim ConnectionString As String =Data Source=" & PublicServerName & "\SQLEXPRESS;Initial Catalog=ABC;Trusted_Connection=Yes; "'

but this time it give error "Login failed for user MachineName\Guest"

I try lot of googling but nothing is helpful. Please provide appropriate guidance to me

Wendelius5-Aug-08 7:28

Re: How can i Do this work Programmatically for SQL EXPRESS 2005

5-Aug-08 7:28

Hi,

You can use SAC command line utility for importing configurations. Restarting services would be most easy with NET START / NET STOP commands and after that the login can be created using T-SQL (CREATE LOGIN).

Hope this helps,

Mika

sunil goyalG5-Aug-08 21:21

Re: How can i Do this work Programmatically for SQL EXPRESS 2005

5-Aug-08 21:21

sir, can i change the default setting during installation of SQL Server.Importanat thing is that i want to Install SQL Server In Silent mode and i want to change all specified setting during Installation

Wendelius6-Aug-08 7:07

Comprare two column headings

6-Aug-08 7:07

Ok,

Most of the settings can be configured during silent installation. The key is TEMPLATE.INI-file. Have a look at this article http://msdn.microsoft.com/en-us/library/ms144259.aspx[^].

I don't remember if all of the things you wanted to do are possible. For example login creation may not be possible, but you can always use a custom command line script, which first runs install and configuration and then use (for example) OSQL to create login silently.

Hope this helps,

Mika

DFlat4Now5-Aug-08 6:24

DFlat4Now

5-Aug-08 6:24

I have one table and the columns are exactly as they should be. I am sent new data that needs to match the columns headings of this first table exactly. How do I create a sql query (it's really in Access) that does a quick compare and show me any differences or how the new violates the standard?

Re: Comprare two column headings

DerekFL5-Aug-08 7:02

DerekFL

5-Aug-08 7:02

By violates do you mean violates a foreign key?

Re: Comprare two column headings

DFlat4Now5-Aug-08 8:30

DFlat4Now

5-Aug-08 8:30

There are no keys. I simply want to check the column headings with a table we know is correct with the new incoming table. How does the new table (if at all) differ from the standard (I know the columns are right) table.

How to convert variant_t data type to char* or char array or const char* or CString data type?

yklim5-Aug-08 6:03

yklim

5-Aug-08 6:03

I use ado _RecordsetPtr to get an item from oracle database using GetValue()to read a field named Source which is of varchar2(10) datatype.

variant_t vtSource = rst->Fields->GetItem("SOURCE")->GetValue();

Can anyone show me sample code on how to convert vtSource which is of variant_t data type to char* or char array or const char* or CString data type?

Output Parameter value

ThangamSundar5-Aug-08 2:40

ThangamSundar

5-Aug-08 2:40

How to get the output parameter value

Re: Output Parameter value

Blue_Boy5-Aug-08 2:51

Blue_Boy

5-Aug-08 2:51

Check this google result.[^]

I Love T-SQL
"Don't torture yourself,let the life to do it for you."

Re: Output Parameter value

John_Adams5-Aug-08 19:12

John_Adams

5-Aug-08 19:12

Hi,

Please go take a look at the following article of Microsoft.
http://support.microsoft.com/kb/262499[^]

Hope this helps Smile | :)

Regards,
John Adams
ComponentOne LLC

Download Vista Compatiable SQL Server EXPRESS

sunil goyalG5-Aug-08 1:12

5-Aug-08 1:12

hi all,
can any body help me to find the SQL Server Express which is compatible to Vista. If yes then Please provide the link So i can download the SQL Server

Blue_Boy5-Aug-08 3:06

Blue_Boy

5-Aug-08 3:06

Download Express 1.9 Vista Compatible [^]

I Love T-SQL
"Don't torture yourself,let the life to do it for you."

sunil goyalG5-Aug-08 5:37

5-Aug-08 5:37

Are you sure that the link,Provide by you is For SQL Express(Compatible with vista) Big Grin | :-D

Wendelius5-Aug-08 7:33

5-Aug-08 7:33

Hi,

The registration and download page can be found here http://www.microsoft.com/sql/editions/express/default.mspx[^]

Mika

sunil goyalG7-Aug-08 5:35

7-Aug-08 5:35

sir,
perhaps this version is not compatible with VISTA since when i run this, this system prompt me that this product has known comaptibility issue .Please suggest

Wendelius7-Aug-08 6:29

7-Aug-08 6:29

Did you download SQL Express 2005 and not MSDE. MSDE is not compatible with Vista. For example I have SQL Server 2005 downloaded from there and I'm running it on Vista.

Also, are you sure that you don't have any earlier Beta or CTP versions of SQL Server 2005 or .NET framework 2.0? These are not compatible with the product version.

Here's another link directly to download page and information about installation.

http://www.microsoft.com/express/sql/download/default.aspx[^]

Mika

Wendelius16-Aug-08 21:02

How to lock an Active Directory user account

16-Aug-08 21:02

If you're still having this problem, you can also download directly from
http://www.microsoft.com/downloads/details.aspx?FamilyID=31711d5d-725c-4afa-9d65-e4465cdff1e7&displaylang=en[^]

Mika

AnoopSihag5-Aug-08 1:09

AnoopSihag

5-Aug-08 1:09

I have an IMS project which authenticate user against the AD. Now, I want that if user enter the wrong password 3 timesm his account get the lock .

to lock user i am using

objDirectEntry.Properties["LockOutTime"].Value = 1;
objDirectEntry.CommitChanges();

if i set any value rather than 0 to objDirectEntry.Properties["LockOutTime"] , it throw exception.

Anoop Sihag

connection string

NiloofarNoroozi5-Aug-08 0:42

NiloofarNoroozi

5-Aug-08 0:42

When i have to sql sever 2005,How to make connection string?

please help to me

Ashfield5-Aug-08 1:09

Ashfield

5-Aug-08 1:09

If you can't figure this out you really shouldn't be writing code. Try Google.

Bob
Ashfield Consultants Ltd

NiloofarNoroozi5-Aug-08 1:27

NiloofarNoroozi

5-Aug-08 1:27

I have 2 instance.
i used this:
Driver={SQL Native Client};Server=myServerName\theInstanceName;Database=myDataBase;Trusted_Connection=yes;
but i have a problem yet.
my eroor:
recognize escape sequence
help me please

SimulationofSai5-Aug-08 2:10

SimulationofSai

5-Aug-08 2:10

I guess you're coding in C#.

Try

connstring = @"Driver={SQL Native Client};Server=myServerName\theInstanceName;Database=myDataBase;Trusted_Connection=yes;";<br />
<br />
or<br />
<br />
"Driver={SQL Native Client};Server=myServerName\\theInstanceName;Database=myDataBase;Trusted_Connection=yes;"