How To Change SQL Server Setting So That It Allows

How Do I Change The Default Setting From Connecting To SQL Server 2005?

Hi there!
My provider does not yet support SQL Server 2005, they are still on SQL Server 2000. I put together a very basic login page, but it is crashing everytime I access it because of this problem, and sadly I am not advanced enough as yet to know how to remedy it! Can you help?
Here is the error page, some of it; - Any ideas gratefully received!
Russ.

Server Error in '/' Application.


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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)Source Error:



An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Setting Up MSDE - How To Change SA Password?

I have installed WebMatrix and MSDE and have been able to successfully make a connection from WebMatrix to MSDE. I am used to using SQL Server with Enterprise Manager but I do not have that available to me right now so I'm using MSDE instead. I followed the setup instructions on the WebMatrix tutorial and setup MSDE with an SA password. I would now like to change the password to something else. Is there a command that I can use to do that? There is no Enterprise Manager so I'm kind of stumped. Thanks in advance for your help.

Kathleen

How To Change The Transaction Log File Size To Less Than The Intial Setting.

I have H Drive with 12 GB size.

The Transaction log file of my Database is given in H drive.

i.e H:Krishna_log.LDF.

My database initial setting for the Krishna_log.LDF is 10 GB.
so currently I can see 10 gb file occupied in the H Drive.

very soon my database Krishna_log.LDF is going to increase 10%.

Even though If do Backup/Shrink, it will reduce to the initial to 10 GB.

So all I need is, change the initial size of the
Krishna_log.LDF from 10 GB to 5 GB.

Pls give your suggetions...(I dont mind to shutdown,Restart the Sql server do these changes to achive this Task).


Thanx in advance.

Regards,

Krishna

How Can I Change “Language� Setting Using “Locale Identifier� Of DBPromptInitialize Dialog?

Hi,

I use pIDBPromptInitialize interface for establish a connection to MS SQL Server 2005.
SQL Server has €œus_english€? (LCID=1033) language as default setting.

I use the following part of code to charge LCID (from 1033 to 1049):

CDBPropSet ps3;
ps3.SetGUID(DBPROPSET_DBINIT );
ps3.AddProperty(DBPROP_INIT_LCID, (long)1049);
hr= pIDBProperties->SetProperties(1, &ps3);

hr= pIDBPromptInitialize->PromptDataSource(NULL, GetActiveWindow(),
DBPROMPTOPTIONS_PROPERTYSHEET,
0, NULL, (LPOLESTR)szFilter,
IID_IDBProperties, (IUnknown **)(&pIDBProperties));
...
hr = FDS->Connection->m_spInit->Initialize();

Then I connect to SQL Server successfully.

But SQL Server has LCID=1033 anyway!! Way I didn€™t change it by my code? What is wrong?


But later I try to use some feature of LCID=1049 (date conversation)


How can I change €œLanguage€? setting to, for example, Russian (LCID=1049) using pIDBPromptInitialize
G.

Change Default Zoom Setting For Reports Viewed On Report Manager Web Site

I've tried changing the default zoom setting by editing the RSReportServer.config file to include

<Configuration>

<DeviceInfo>

<Zoom>Page Width</Zoom>
</DeviceInfo>
</Configuration>
under the

<Render>

<Extension Name = "HTML4.0" etc.
However, all reports still show up with the zoom setting at 100% on the toolbar.
I stop and restart the Report Server Service and it comes up OK so I know my XML syntax is cool. What am I doing wrong?

This is on a 2005 Report Server. Reports are built in VS2005 Report Designer and deployed to the Report Server directly. Reports are accessed via IE7 browser.

Setting Timeout In ASP.NET Vs Setting Timeout In SQL Server

In my ASP.NET app, I'm executing a stored procedure via a SQLCommand the searches a customer database. I believe the default timeout is 90 seconds. I'm curious of what happens to the SQL Server Stored Procedure after timing out from the ASP.NET application. Does it timeout at the same time or do you have to set up a value in SQL Server?

Instructions For Setting Up A Sybase ASE Server As A SQL Server 2005 Linked Server?

I have a Sybase Adaptive Server Enterprise server which I need to set up as a linked server in SQL Server 2005.  The Sybase server is version 12.5.2, and the Sybase ODBC driver version is 4.20.00.67.  I have already installed the Sybase client software on the server.


I also created a SystemDSN on the SQL Server to connect to the Sybase server.  I tested the connection and it was able to connect.

I ran the following code to create the linked server:

<code>

EXEC master.dbo.sp_addlinkedserver @server = N'LinkedServerName', @srvproduct=N'Sybase', @provider=N'MSDASQL', @datasrc=N'Sybase System DSN', @provstr=N'"Provider=Sybase.ASEOLEDBProvider;Server Name=servername,5000;Initial Catalog=databasename;User Id=username;Password=password"'

</code>

I then ran sp_tables_ex to make sure I could view the tables in the Sybase database.  Here is the error message I get:

<code>

OLE DB provider "MSDASQL" for linked server "LinkedServerName" returned message "[DataDirect][ODBC Sybase Wire Protocol driver]Error parsing connect string at offset 13. ".

Msg 7303, Level 16, State 1, Procedure sp_tables_ex, Line 41

Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "LinkedServerName".

</code>

Any ideas what is happening here?

Setting Up Replication On SQL Server 2000 Using Distributor Running On SQL Server 2005

Hi

I have a setup where I need to replicate the database which is actually subscribing from another database. The current setup is all in SQL Server 2000. I need to now setup a Distrbutor on a SQL server 2005 and publish the database using this distributor to another server on SQL server 2000.



Has anybody done this before. If yes what will I need to check. Can you please let me know :-



1) SQL Server 2000 which SP should be installed to support this enviroment.

2) SQL Server 2005 which SP should be installed to support this environment.

3) Any thing that I need to look out for.



Thanks for any inputs on this.



Regards

Setting Back Up Sql Server Express And The Sql Server Management Studio

I am having a nightmare of a time with my Sql Server 2005 Express. My computer crashed on Friday the 13th - of course. I saved all my files onto another drive and wiped out C: I brought everything back in but I started a new file for my Visual Basic projects. After asking questions I found this was a major no-no So I brought my original folder back in. This solved some of my problems I was having with Visual Studio and Visual Web, but I am continuing to have problems with Sql Server. I will explain these two problem they may be related, I don't know. When I run my Visual Website on a server I get this message:

An attempt to attach an auto-named database for file(then my file name)failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

And my second problem is when I attempt to run Sql Server Management Studio Express I get this error message:

There is no editor available for (then my file name) .mdf

Make sure the application for file type(.mdf)is installed.

Setting Up An SQL Server

Hello, Iam new at this SQL stuff and want to setup an SQL Server at work and need to know what do i need to use this software. I have a EVAL version of 6.5 and was told you need MSACCES or Visual Basic. Is there anything else that i need to use this? Thanks!!

Setting Up SQL Server

What is the best way to set up a sql server db that will be accessed via web(asp/ado) and windows (vb/ado) environemnts. I am concerned with security and authentication.

Thanks!

Setting Server Name In Trace

I am working with 3 sql 7.0 servers (Servers A, B, C) and am trying to create a trace via profiler to run against server B.

Every trace that I create keeps pointing to server A even though I have server B defined in the properties of the trace - (when I edit the trace properties it REALLY does show server B). I have server B defined in the screen where you 'Select the SQL Server to run the trace on'. I even used the wizard to run one of the canned traces and it still points to server A. Every trace I set up runs against server A. Can anyone think of what the heck I'm doin' wrong? Is is a configuration setting somewhere?

Setting Up NT Security In SQL Server 7

Does anyone know the best way to set up NT security. It seems a little confusing as to how to set up NT groups and assign permissions (where do the roles come into it?).

Any help would be much appreciated

thanks

Paul

Setting Up Email With SQL Server 7.0

Is there anyway to set up SQLMail without using Windows Messaging and using a MAPI Client?


Thanks,
Scott Hughes

Setting Up Database On A New Server

Hi,

There has been a lot of discussion about moving single databases or devices in same server. Can someone suggest the most simplest method to set up a identical server with all the logins, permissions and password etc?

Building a new server with sp_help_revdatabase and dumps/loads is relatively easy but moving the master is confusing to me. I should run the new server and databases for a little testing period (with diffrent server name, of course) and then go live by dropping the old and by adding the new. I remember someone said that this would be as easy as copying master.dat to new machine (when servers are identical), any experience or other suggestions?

TIA,
Al

Setting Up OLAP Server: Need Help!

:eek:
I am having trouble setting my SQL databases up as analysis services databases in SQL Server '05. Does anyone know how to help me???? I have lots of cubes to build, but I can't get the datasources there.
Thanks much for any advice.
mbunch@bighammer.com

Help With Setting Up SQL Server Express.

How do I find out what port my server is listening on? I'm trying to connect to my database locally to install Vignette Portal. And no matter what I try, nothing works. I think it is listening on port 1433. But there is no way to be sure. Should something come up if I hit localhost:1433 in my browser? Because, when I do that, nothing comes up.

Please help.

Setting Up Linked Server

Set up linked server for windows user.please explain step by step

Registry Key Setting For MS SQL Server

I am installing my application thru Installshield Professional 5. Howto know whether MS SQL Server is installed or not on the machine onwhich i am installing my application. What is the registry key thruwhich we can find this.

Setting Up New SQL Server System.

Hi all,


I am soon to be setting up a new server that is to have SQL Server 2005 on it.

The server has 2 x Quad Core Xeon CPUs, 16Gb of RAM and 2x73Gb HDDs in RAID1 configuration - the whole running under Windows Server 2003 x64. (The data will be on an external RAID disk array, so the 73Gb is just for the O/S and utils.)


I was reading that Windows will, by default, create a page file of (RAM size) + 1Mb, though my old-school education says use a page file of 1.5 times the RAM size. Then again, 16Gb is a whole pile of RAM and do I really want a page file of 24Gb when I only have 73Gb of HD space..? Is it worth partitioning the HDD into two or just leave it whole?


I'm looking for guidance from knowledgeable types (that's you chaps) who could offer advice on how best to implement SQL Server on a system of this spec.

I've also thought about assigning different processor affinitie to Analysis Services and the Database Engine - does anyone have any strong thoughts either way on the benefits of this?


Many thanks,
Robo

Is It Secure Setting FTP On Server

Is it secure setting ftp on the server so that i can use this ftp task in ssis.

I want to get some files located on the sever to my machine.

right now it does not work.

Is it safe setting ftp on the server???????

Setting Up An Sql Server To Allow Remote Connections To It

I have a database on my computer with a series of tables in it.
I have sql server management studio express 2005 handling them.
How would I make it so I can access the database remotely, over the internet (a non-local network)

Setting The Server&#39;s Clock Back

How does SQL Server respond when the NT Server's clock is set to a time that is earlier than the current time? Someone on my team seems to think that this is a problem for SQL Server, but I am not sure.

SQL Server 7.0 And Setting Column Privileges

How do you set column privileges in the SQL Server 7.0’s Enterprise Manager. It was so easy in 6.5’s but now it seems that the only way to do it is through the stored procedure.

Hash Bucket Setting For Server With 1 Gig Of RAM ?

Need Help In Setting Up Sql Mail On Sql Server 2000

Iam not sure why Iam not able to successfully set up sql mail. here are the steps I follow:

1. I Created a user account and password to be used for sql server and sql agent as a service account.( Domain Namesqlservice )
2. Logged off window 2000 then log in with the same account I created in step one.
3. double clicked mail icon in control panel to set up a mail account by specifying the following:
pop :pop.erols.com
smtp: smtp.erols.com
I choose POP instead of IMAP to set up the mail account
4.tested the account by opening Outlook and was able to send and recieve mail via Outlook.

So far so good
I assume that I have already (a)created a service account to be used for sql server and sql agen mail account (b) created a mail account (c)tested the mail.
5. I opened sql server and clicked on the mail in the management console to test the sql mail by typing the same mail account in the text box, then clicking test.... I got an error message the MAPI is not set up and it is not connecting to any profile.

another error I got was Error :xp_mapi profile : failed with mail error 0x80040106
Here are some questions that I am not sure about.
Q1. Do I need to set up smtp service in service tab to use same account as sql server/ sql agent. It is using local system account now
Q2. the above steps are correct, I guess so, so what is the reason not being able to set up the mail profile to be used by sql server mail

Thanks for your help
Ali

Setting Up Linked Server To IBM AS400

I am trying to set up a linked server in MSSQL to an IBM AS400 using the IBM AS400 OLE DB Provider. The New Linked Server dialog box asks for properties Product Name and Data Source. I would like to know from someone who has successfully set up a linked server to an AS400 what the specific syntax in the properties needs to be. I have reviewed the OLB section on sp_addlinkedserver, and while this is helpful and gives many specific examples, I need an example for an AS400. Thank you to anyone who can help!

Setting Up A Testing Server To MS SQL Using Dreamweaver MX

Hi,
I'm new to the whole MS SQL server thing, have been using Access in past developments via the development platform in Dreamweaver.

Now I'm making the leap to MS SQL and still want to use Dreamweaver to handle some of the development aspects, does anyone know how or what i would need to do to have a direct connection with the server in dreamweaver?

I've setup an ODBC connection with my hosting providers already.

THANKS!

SQL Server 2008 :: Min And Max Memory Setting

I have an issue with my production server regarding memory usage (Memory Utilization is above 95%.). Memory is : 12 GB and the service that is consuming the majority of memory 88%/10.5GB is sqlserver.exe. So it would appear that MSSQL is not set to restrict the amount of memory it uses ? How much should I set for min and max memory ? the defauld is min memory : 0 and max : 2 TB

Assistance Setting Up Master Job Server

What considerations do I need to take into account if trying to enlist a server into a master server when (a) both instances are on different physical servers and the SQL Server and SQL Server Agent services run under different domain accounts?

The reason I ask is when attempting to create a master server through the SSMS wizard, I receive these errors:


Enlist TSX Progress

- Create MSXOperator (Success)
* Checking for an existing MSXOperator.
* Updating existing MSXOperator.
* Successfully updated MSXOperator.

- Make sure the Agent service for 'MYMSXINSTANCE' is running (Error)
Messages
* An exception occurred in SMO while trying to manage a service. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) (mscorlib)

- Ensure the agent startup account for 'MYTSXINSTANCE' has rights to login as a target server (Error)
* Checking to see if the starup account for 'MYTSXINSTANCE' already exists.
Messages
* An exception occurred in SMO while trying to manage a service. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) (mscorlib)

- Enlist 'MYTSXINSTANCE' into 'MYMSXINSTANCE' (Error)
* Enlisting target server 'MYTSXINSTANCE' with master server 'MYMSXINSTANCE'.
* Using new enlistment method.
Messages
* MSX enlist failed for JobServer 'MYTSXINSTANCE'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=MSX+enlist+JobServer&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The enlist operation failed (reason: SQLServerAgent Error: Unable to connect to MSX 'MYMSXINSTANCE'.) (Microsoft SQL Server, Error: 22026)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=22026&LinkId=20476


Now, the first two errors are what are puzzling me. I'm certain I can address the third and last error by making the accounts the SQL Server Agent services run as the necessary SQL permissions on each instance.

I've tried making NT AuthoritySYSTEM accounts on both servers, no luck. Any suggestions?

Setting Up New Sql Server For Solomon Dynamics

can someone explain or link me to some reading material regarding best practice for setting up a sql server (solomon dynamics server)... we are using windows server 2003 R2 and SQL Server 2005. We have partitioned two drives... one 36GB for solomon Log files and 36GB for solomon Data files... our actual solomon database will be hosted on a huge MSA1000 device. Just wondering if this is the best practice for setting it up

Setting Max Server Memory In 64 Bit Machine

I am running SQL 2005 Standard under Windows 2003 Standard with 8 GB of RAM in one of our 64 bit servers; I noticed min server memory was set for some reason to 128 MB and max server memory to 6114 MB by the previous DBA. We plan to upgrade it to 32 GB. What is the best approach when changing those values ? Should I change those values to the defaults (0 - 2147483647) or create min and max boundaries? . This box is only utilzed by SQL.

Also I know that those changes are reconfigured dynamically so no need to reboot, but would this place any performance hit in the server and should I use Management studio or sp_configure ? (for some reason I don't trust Management studio for these type of changes :))

Thanks,

Carlos