Error When Logging On To Sql Server Proper

May 16, 2006

I am getting the following error.

“The user instance login flag is not supported on this version of SQL Server. The connection will be closed.�
Background
  i created a site on my development machine, and every thing worked,
  this computer is running sql EX.
  I uploaded the site to the production server (running sql 2005 standard) and changed the connection string (i have used this connection string with other dB’s to display data only, and it works) but i tried it with the ASPNETDB.mdf in the AppData folder and i get the above message.
 
Do i have to set some special permissions in the db for it to work.
 I need to be able to insert, update, and delete in this app.

View 3 Replies


ADVERTISEMENT

Logging To Event Viewer Fails But SQL Server Logging Works OK - Why?

Jun 18, 2007

Greetings,



I am developing a package on my local workstation. I have defined two logging service providers. One is for SQL Server and the other is for the Windows Event Log. I am using the Dts.Log method in a script task to write log entries.



Logging is working properly with the SQL Server provider and rows are being inserted into the sysdtslog90 table. However, the only events that are being logged in the Windows Event Log are the package start and end events which I believe SSIS is doing automatically anyway.



Is there something I need to do to enable WIndows Event Log logging other than defining a log provider and making sure it is checked active? Won't SSIS write to two different logs with one Dts.Log call? Any ideas on what might be going wrong with my approach?



Thanks,

BCB

View 3 Replies View Related

(different) Error Logging Onto Sql Server / Database Help

May 26, 2004

When trying to connect to my sql server I get the following error :

Connection Failed :
SQLState:'08001'
SQL Server Error : 17
[DBNETLIB][ConnectionOpen(Connect))(.[SQL Server Does not exist or access denied]

im not sure how to give a user access or give the user the right password


I get the same error when trying to create a database and connect to the server.

Im working on xp pro, and using VS.net. also theres a red x next to the cylinder of the sql server, so im assuming im doing something wrong.

View 3 Replies View Related

SQL Server Error Logs: What Events Is It Logging? Can We Edit And Include DDL Events?

Jun 20, 2007

Hello experts. I have been searching for anything about this but found very little. What are the events logged in SQL Server Error Logs aside from Successful/Failed Login, Backup/Restore/Recover database and, start/init sql server? Can we configure this to log other events, like CREATE or DBCC events for example? If so, how? Thanks a lot.

View 1 Replies View Related

Error With Default SSIS Error Logging

Nov 21, 2007

I click on menu item SSIS and enable logging to my SQL Database (SSIS log provider for SQL Server). When I run the package it runs fine for the first time. Upon subsequent runs I get the following error.

[Log provider "SSIS log provider for SQL Server"] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80040E14 Description: "There is already an object named 'sysdtslog90' in the database.".

It seems like I need to drop the table every time to avoid this error. Is there a way I can log all package logs to single table historically? Any weblink or tip is appreciated.

Thanks!

Palak Mody

View 3 Replies View Related

SQL Server 2000 - Proper Backup Procedures

Jul 24, 2006

Hi everyone I am fairly new to SQL server and need some help with creating backups. I am a little confused whether to append or overwrite my backup data when saving full, differential and transaction log backups to disk. Below is my current backup schedule.

1) A full backup every night at 2:00a.m. that overwrites my existing backup. Should this be an appended backup? Wouldn't my file keep growing? How do I manage the backup file size?
2) Differential backups every two hours that is set to append. How do I stop this file from growing? Should I be controlling the size of my backups through the backup set expiry option?

How do I incorporate transaction logs into my backup schedule and manage the size of the log? Should the log backups also be appended or overwriten?

I appreciate everyones help in advance.

View 8 Replies View Related

Error While Logging

Apr 15, 2008

Hi all,

I am getting the following error when I log into SQL server using MS SQL Server Management Studio.

"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.) (.Net SqlClient Data Provider)".

I tried to allow remote connections using Surface Area Configuration, but it is not allowing me to do so.

I am not sure what I need to do. Anybody, please advice.

Thanks & Regards

View 20 Replies View Related

Error Logging

Jun 18, 2007

Hey all

I'm using the Execute SQL Task to import error messages into a table. I'm using the following:

"INSERT INTO SSISLog (EventDescription)
VALUES (" +@[System::ErrorDescription]+")"

I've got an import task with deliberate errors in the file to be imported to test the error logging task. When I execute it, I get the following messages:

[Execute SQL Task] Error: Executing the query "INSERT INTO SSISLog (EventDescription) VALUES (An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Invalid character value for cast specification". )" failed with the following error: "The name 'An' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.


[Execute SQL Task] Error: Executing the query "INSERT INTO SSISLog (EventDescription) VALUES (There was an error with input column "IssueNo" (94) on input "Destination Input" (68). The column status returned was: "The value could not be converted because of a potential loss of data.". )" failed with the following error: "The name 'There' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

[Execute SQL Task] Error: Executing the query "INSERT INTO SSISLog (EventDescription) VALUES (The "input "Destination Input" (68)" failed because error code 0xC0209077 occurred, and the error row disposition on "input "Destination Input" (68)" specifies failure on error. An error occurred on the specified object of the specified component. )" failed with the following error: "The name 'The' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

[Execute SQL Task] Error: Executing the query "INSERT INTO SSISLog (EventDescription) VALUES (The ProcessInput method on component "Destination - tbl_clients" (55) failed with error code 0xC0209029. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. )" failed with the following error: "The name 'The' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

[Execute SQL Task] Error: Executing the query "INSERT INTO SSISLog (EventDescription) VALUES (Thread "WorkThread0" has exited with error code 0xC0209029. )" failed with the following error: "The name 'Thread' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Any ideas?

Thank you in advance

Rupa

View 4 Replies View Related

Logging Package Name For Any Event In Sysdtslog90 Logging Table

Oct 17, 2007



Hi,
I decided to use the SQL Server log provider to store logging data of all my Integration Services packages. I also created some reports about this data for operating purposes.
I have a problem occurs the name of the executing package is not always written to the log,but the name of the single task which failed. But that is not very useful information for operating, because I do not see any chance to get the name of the package by the information which is logged in the sysdtslog90 table in the database which I defined for SSIS Logging.

How do I configure the package to always log the package information into the table, too?


Best regards,
Stefoon

View 5 Replies View Related

SQL Server 2008 :: Unable To Use Proper Quotes In The Statement?

May 22, 2015

I'm automating some of the TDE stuff and while doing so stuck somewhere. I'm unable to use section [ENCRYPTION BY PASSWORD = ''"' + @db_pswd + '"'' ] properly as in if the user (DBA) wants to pass a single quote(') in the password, then it will fail.

I used quoted_identifier OFF/ON outside my proc, no luck still.

--Create a backup of the certificate with a private key and store in a secure location

select @cmd = 'BACKUP CERTIFICATE ' + @cert_nm + ' TO FILE = ''' + @cert_file + '''' +
' WITH PRIVATE KEY ( FILE = ''' + @key_file + ''', ENCRYPTION BY PASSWORD = ''"' + @db_pswd + '"'' );'
select @cmd
--EXEC sp_executesql @cmd

View 9 Replies View Related

Logging Error Messages

May 7, 2002

Hi,

How can I avoid certain messages from SQL Server being recorded into the Event viewer ?
For example, every time I truncate the transaction log with 'Backup log with truncate_only', It is being recorded into the Event viewer as an Error. But, I know that it is not an error.
How can I avoid this ?

Thanks

View 1 Replies View Related

DBCC Error Logging

Feb 15, 2007

Hello,

I am running some DBCC checks as a routine maintenance task on my sql server 2000 servers. I am running DBCC CHECKDB, DBCC CHECKCONSTRAINTS and DBCC CHECKCATALOG. I have established a set of procedures and tables to capture the output from the error log after running these DBCC commands. After running all three, it appears the same info captured for CHECKDB is not logged for these two: CHECKCONSTRAINTS and CHECKCATALOG. Does anyone know why these are not logged and if it is even necessary for me to run these 2 extra DBCC checks? If not, can anyone recommend what database consistency checks should be executed on a daily basis for a production database server?

DBCC CHECKDB (DBNAME) executed by lshores found 0 errors and repaired 0 errors. Elapsed time: 0 hours 20 minutes 32 seconds.

View 1 Replies View Related

Custom Error Logging

Dec 22, 2007

Hi,

I have a small requirement in SSIS Error Logging Mechanism.
Presently in my SSIS package i am using a File Connection Manager for creating a Log file.
I have a problem on this regard. Every time when i am executing my DTS package, the error log messages are getting appended to my error log at OS level (say D:error_messg.log). And for this reason whenever my DTS package is getting executed the size of the file is keep on increasing and there by killing my disk space.

I have a requirement for this error logging mechanism. At any time my log file should not exceed more than 20MB.
Or can we remove the log events a week ago or say more than 2 days or say. Just ensuring the log file do not fill up the disk space eventually.

How can we do this?
Any suggestions are greatly appreciated.

Thanks & Regards

View 4 Replies View Related

Proper Way To Truncate Log After Performing Full Backup (SQL Server 2000)

Jan 29, 2007

Hello all - I have a SQL Server 2000 database setup using the Full Recovery Model. Each night, we backup the entire database, and as such would like to truncate the log at this time as well.

Is the best way to do this to also backup the Transaction Log, and then perform a DBCC SHRINKFILE command? It just seems like there should be an easier way...?

Thanks!

View 1 Replies View Related

Error Message Logging In (aspnetDB)

May 17, 2008

Hi,
construir
build
© Webster's
I am programing a site in aspnet 2005
I contructed space from my host for my Database.
In the web.config I added a connection string with username and password <configuration>
<appSettings/><connectionStrings><add name="oseriConnectionString" connectionString="Data Source=sql2005.digiweb.com.br;
Initial Catalog=zzz;
User Id=xxx;Password=yyy"
providerName="System.Data.SqlClient"/>
and I have access to this database when I work on my station as well when I am working on line.
Unfortunately I also gained for free the ASPNETDB.mdf file...
The ASPNETDB is automaticaly created in the ~/app_data together with a web.config.
I use the following connectionstring:<add name="aspNetDBConnectionString" connectionString="Data Source=sql2005.digiweb.com.br;
initial Cataloge=htdocsapp_DataASPNETDB.MDF;
Integrated Security=True"/>
Working on my station I have access to the aspnetDB file, I can add users roles etc..
notice that I use ConnectionString to my provider!
My first question is whether I really load the information also to the file in my site Because on my station I can find the changes.
If the answer is no then do I load the file simply through the FTP ?
and how can I open the file in the provider side?
In any case when I run the site on line, trying to log in, I get an error message 26
 
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)
If I insert a wrong password I get the same error message. Which means that I don’t have access to the file.
I definitely could use some help since from my provider I get none.
Thank you
Dov Kruman

View 4 Replies View Related

Error Logging In CLR Stored Procedures

Jun 14, 2005

Hello,I was wondering if there were any built-in objects to handle error handling, in any of the SQL Server objects, or just to use event log or trace or debug or something like that.  Or is it not recommended at all to use try.. catch, for whatever reason.Thanks a lot.

View 4 Replies View Related

How Can I Turn Off SQL Executive Error Logging?

Jun 29, 1998

I presently have Error Logging turned on for the SQL Executive, but I no longer want it. When I
open up the "Configure SQL Executive" window under the Server menu, the
"Error Log File" field is dimmed and there is no option to turn it off.

How do I turn off logging for SQL Executive?

View 1 Replies View Related

How To Add Error Logging File In SSIS

Jun 6, 2008

Just like in DTS where we can add error file so that if the DTS package fails we can see what caused the DTS to fail, likewise do we have anything like error logging file in SSIS. I greatly appreciate your help on this. thanks!!

View 1 Replies View Related

Change Error Logging For Sys.sp_MSrepl_raiseerror

Mar 16, 2007

I have merge replication setup to a bunch of mobile subscribers. I want everything managed from the server and I want everything to run continuously. The reason we want this is that we want subscribers to automatically synchronize data within 60 seconds of plugging into the network from any location. We do not want to write anything to have to detect connectivity and initiate it. We do not want it initiated from a subscriber either. This creates a SEVERE logging issue and has halted a roll out at 2 different customers. We can't get beyond about 60 subscribers on a system that was running 3700 subscribers in SQL Server 2000. The server quite literally freezes and becomes non-responsive 1 - 2 times per day. We've tracked this back to the volume of logging into the Windows event log that is being caused by the replication engine.

When subscribers are disconnected, they throw constant errors, to the tune of 1 error every 2 minutes into the SQL Server error log as well as the Windows event log. This is because someone decided that these should be level 18 errors. There is no error. The publisher could not contact the subscriber, so I want it to simply log an error, shut up, go back to sleep, and then try again. I do NOT want a message in my SQL Server error log and I do NOT want a message in my Windows event log.

We are currently logging over 60,000 messages per day into both the Windows event log and the SQL Server error logs for something that we KNOW is a NORMAL operational state of the system. The merge agent doesn't have a parameter that I can feed it to ignore 14151 errors.

The culprit is in sys.sp_MSrepl_raiseerror. Since it is a system object, I can't override it and change the severity level of the error. So, right now we are stuck and the SQL Server error log as well as Windows event logs are being rendered quite useless on the system.

The offending code is:

raiserror (14151, 18, -1, @agent, @agent_name, @message)

Does anyone have any idea how I can forcefully change sys.sp_MSrepl_raiseerror or in some other way suppress the logging of 14151 errors from the Windows and SQL Server logs?

View 1 Replies View Related

Error Messages Logging And Copying.

Jul 26, 2006

Hi:

How can I copy the error messages when I execute a SSIS package?. The Progress tab or the Execution results tab both dont have the means to copy the results. I would like the errors to be output to a text file under a directory on my drive system (some thing like C:SSISExecResults.txt). Is this possible?. If so how do I configure my package to output the package execution results to a text file?.

Any help/suggestions/comments highly appreciated.

Thanks

AK

View 1 Replies View Related

Dbbc Not Logging Db Name In Error Log Correctly?

May 2, 2007

In the SQL error log it is not showing the actual database that was checked. Below is the entries for user databases. What gives?





2007-05-01 18:20:36.28 spid99 DBCC CHECKDB (master) WITH no_infomsgs executed by

2007-05-01 18:20:37.64 spid99 DBCC CHECKDB (mssqlsystemresource) WITH no_infomsgs executed by

2007-05-01 18:20:38.20 spid99 DBCC CHECKDB (master) WITH no_infomsgs executed .
2007-05-01 18:20:39.54 spid99 DBCC CHECKDB (mssqlsystemresource) WITH no_infomsgs executed by

2007-05-01 18:20:40.21 spid99 DBCC CHECKDB (master) WITH no_infomsgs executed by

2007-05-01 18:20:41.56 spid99 DBCC CHECKDB (mssqlsystemresource) WITH no_infomsgs executed by

View 4 Replies View Related

SQL Server 2008 :: Select Statements To Output Files With Proper Datestamp

Jun 11, 2015

I have few complex queries and I want to extract the output of results to all different dateformatted output files.

How to write the queries?

I know BCP is a solution but any other effective way to implement it?

View 2 Replies View Related

Embedding A DTS Package And Logging/error Reporting

Jan 25, 2007

Hi All,

When the embedded DTS package fails at runtime, and logging has been enabled for the package (and all log events selected for reporting on for the package and the task), the DTS error (i.e. any meaningful errors) are not thrown up to/caught by the SSIS/outer level. All you get is something like:



COMException - error returned from a call to a COM component.



Does anyone have any comments &/or know to get errors thrown from within an embedded DTS package, thrown up to the wrapping SSIS package?



Cheers,



Tamim.

View 1 Replies View Related

Error: 18456, Severity: 14, State: 11 When Logging In

Sep 15, 2007

I just installed SQL Server 2005 with SP2 on Vista. When I try to login from SQL Server Management Studio, I get the following error message in the log:
---
2007-09-15 18:58:02.23 Logon Error: 18456, Severity: 14, State: 11.
2007-09-15 18:58:02.23 Logon Login failed for user '<computer name><user account>'.[CLIENT: <local machine>]
---


Since I can't login, I can't try some of the stuff I have seen here, such as creating new logins etc.

I installed Analysis Server and Integration Services at the same time. Logging in to them both works fine.

I use windows authentication. I don't know if changing that helps, as I don't know how to change it without logging in in the first place...

View 4 Replies View Related

I Cannot Get The SQL Server 2005 Roles, Schemas, Users Correctly Setup For Proper Access

May 16, 2008

I have been struggling with this for a while and cannot get it right. I have read countless articles on the internet as well as MSDN documentation about SQL Server 2005 and no success so far.

What I want is a database with multiple SCHEMAS, DATABASE ROLES and USERS in order to have a finer grade of security to access the various objects.

My schemas are (in order to simplify the situation and provide an example of the setup):

- [dbo] the standard DBO schema which is always default. Contains public objects.
- [com] a special module integrated into the system
- [ofc] contains objects used by back-office only
- [aud] contains objects used for auditing, etc.

Each of these schemas has their fair share of tables, views, functions and stored procedures which have been created appropriately (i.e. CREATE TABLE [ofc].[Addresses]), in other words prefixed by the name of the schema to which they belong.

Then I have created various database roles (don't confuse them with SQL2005 application roles) as follows:

- PublicRole mostly used for viewing, no data alterations
- WorkerRole used by front end processes that need write access to data in [dbo] and [aud]
- OfficeRole used by back-office for dealing with backoffice data (basically [ofc], [aud] stuff)
- AdminRole used by application administrator

Each of these database roles has been defined with owner 'dbo', none of them own any schemas. And last but not least to each of these roles I have selected the above named schemas (dbo, ofc, aud) as securables and for each of those securables schemas I have then given the correct set of GRANT/DENY on the Alter, Control, Delete, Execute, Insert, References, Select, Update, Take ownership and View definition.

As an example, the PublicRole role has been given the following permissions (Y=GRANT, N=DENY):

Table #1 of Application Permissions [dbo] [com] [ofc] [aud]Alter N N N N
Control N N N N Delete N N N N Execute Y Y N Y Insert N N N Y References Y Y N Y Select Y Y N Y Update N N N Y Take ownership N N N N View definition N N N N

And I have the following minimum set of database users defined (the server login has the same name):

- upublic, assigned to PublicRole
- uworker, assigned to WorkerRole
- uoffice, assigned to OfficeRole
- uadmin, assigned to AdminRole

As I understand when I assign these users to a particular custom Database Role, the users inherit the permissions granted to THAT role thus liberating me from having to assign the permissions to each and every user account on the same role.

What I expected was that when I logged in to the database with the upublic user account I would at least be able to view (SELECT at least) ALL the objects with the exception of those in th e[ofc] schema. Unfortunately the account is not able to access ANYTHING at all, I get an error like

"The SELECT permission has been denied on object XYZ, database DB, schema 'dbo'"

So, when I use Management Studio to look at the properties I selected the PublicRole and it showed the upublic user as a member of the role (Members of this role). So far so good.

Then when I switch to the Securables page for this role it shows all the schemas I defined and for each of them the same list shown in Table #1 except it has two lines for each permission, the first for Grantor dbo and the second for Grantor upublic. The first has the same permissions I assigned to the role (as shown on Table #1) but the 2nd does not show a checkmark on either GRANT or DENY!!! For example ([x] = checked, [ ] unchecked):

Table #2 Explicit permissions for Securable
Permission Grantor Grant Grant-with Deny
Select dbo [x] [ ] [ ] Select upublic [ ] [ ] [ ]

What am I doing wrong here? Apparently I then have to repeat the whole grant/deny for EACH and EVERY USER I define when the idea was that I would grant/deny on the database role and every member of that role would inherit those permissions automatically.

View 3 Replies View Related

SQL 2000 Transactional Replication-skiperrors Parameter With Error Logging

Mar 15, 2007

I have used skiperrors parameter for 2601,2627 and 20598 errors in my Transaction replication setup. When transactions with above error are encountered, its skipped but I€™m not getting sql command that is skipped in MSrepl_errors table. Since SQL server 2000 is not saving transaction sequence number in the MSrepl_errors we are not getting the command, which have the errors.


Is there any way to track the commands those are skipped in transactional replication.

View 11 Replies View Related

Analysis Services Processing Task: Logging And Error Handling

Mar 5, 2007

I have an Analysis Services Processing Task in my SSIS package. I run the SSIS package using SQL Server job, the running of the package is a job step.

When I process manually the analysis services objects (in practise cubes) using dtexec utility I get a lot of log. In case the processing fails I get error messages that quite well describe the error. But when I run the job the only information I get in the job log is that the job step failed. I know the failure happens in the Analysis Services Processing Task.

Is there any way in SSIS to get a) the log of the Analysis Services processing or b) the error messages of the Analysis Services processing? Or should the processing be done some other way than I've been doing?

View 4 Replies View Related

Tie Together Custom Logging And SSIS Logging?

Sep 12, 2005

I recently read the project real ETL design best practices whitepaper. I too, want to do custom logging as I do today, and also use SSIS logging. The paper recommended using the variable system::PackageExecutionId to tie the 2 logging methods together.

View 4 Replies View Related

Flat File Loading Problem -&&> Messed Up Delimiters And Error Logging Issue

Aug 31, 2007

Hey Everyone,

I have a Data-Flow task embedded in a Sequence Container (does not fail component on error) on the Control Flow panel of the SSIS designer. This data flow task contains a connection to a Flat File Source -> A Data Transformation -> Into an OLE Db Destination.

The problem is that the Flat File isn't always delimited properly -> the client cannot be relied on to do this.

My question is when the delimiters are messed up, how can I capture the offending error row(s) from the Flat File Source?

What I've tried:
1) Set every column in the source flat file on error to: Redirect Row
2) Added a Script Transformation to pull the description and the record id out of the offending row
3) Added an Error file flat file destination to the end of the flow.

The package always fails on the Flat File Source and never Redirects the offending Row to the error output - I never see my onError Script Transformation go Green, Red, or Yellow - SSIS doesn't let it get there.

I'm really new to SSIS so sorry if this is a super basic question.

Here is the Error Text:

[Source - InventTable_csv [1]] Error: The column delimiter for column "RECID" was not found.
[Source - InventTable_csv [1]] Error: An error occurred while processing file "C:------InventTable.csv" on data row 15228.
[DTS.Pipeline] Error: The PrimeOutput method on component "Source - InventTable_csv" (1) returned error code 0xC0202092. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.
[DTS.Pipeline] Error: Thread "SourceThread0" has exited with error code 0xC0047038.

I do have the MaxErrorCount set to 1 on the Data Flow Task but still think I should see my script task execute and a log entry be generated.

Any Ideas?

Matt

View 15 Replies View Related

Logging Server

Apr 24, 2007

Hi Guys hope someone can help with this one, I am working on SQL 2000 and having problem with logging a new server instance to be run in query analyzer let me explain,

I have the default sql server and then also an instance called sqlone on the same machine for study reasons.

However after loading the new instance on and then registering it in enterprise manager it appears fine on there, but I am having problem only in query analyzer the sqlone instance does not appear in the drop down menu so that I can select too work on that server

Only reason I need this is as I am practicing adding linked servers and without the second instance being visible it won't work correctly.

For other infomation the instance ok in the enterprise manager, server manager and then in the computer management in the administrative tools in the control panel.

Any advice please people

Thanks
Neil G

View 2 Replies View Related

Default NT Accounts Even If We Have Proper Service Accounts In Server?

Jul 23, 2015

Do we still need the below service accounts in SQL 2008+ version even if we have proper SQL service accounts added in the logins?

[NT AUTHORITYSYSTEM]
[NT ServiceMSSQLSERVER]
[NT SERVICEReportServer]
[NT SERVICESQLSERVERAGENT]
[NT SERVICESQLWriter]
[NT SERVICEWinmgmt]

View 0 Replies View Related

SQL Server Mobile Tutorial And Getting Proper Mobile DB Installation

Apr 24, 2006

Hi folks, I'm new to Windows Mobile progamming, and new to this forum. Apologies in advance if I'm asking a boneheaded question, but I've done searches and can't find anything directly applicable to my problem.

I'm currently walking through the published MS tutorial in setting up an SQL Server 2005 Mobile application that subscribes to a publication on SQL Server 2005 to exchange information.

I've gotten almost all the way through... successfully set up the server components, creating the publication, etc. On the mobile side, I've been able run the cab files to install the SQL Mobile components and to create the project, add the reference to the dll, and instantiate an engine object. It compiles.

The step in the tutorial after that, though, where you specify the data source from the "data" menu, I've got a problem. When I try to use the "new connection" dialog from choosing the data connection, "MS SQL Server Mobile Edition" doesn't show up as a choice. I've tried choosing any of the other combinations, and in teh subsequent "Connection properties" section my database, SQLMobile (as in their sample) is available, but I get an error when I choose it and click OK. Clicking on "Test Connection" gives me a connection successful message.

My guess is that something about the Mobile server side components is not installed correctly on my development machine, but honestly I have no idea how to begin to fix it. Has anyone seen this problem before and know how to resolve it?

Your time and any knowledge sharing is greatly appreciated.
Thank you,
-Dana

View 8 Replies View Related

SQL Server Admin 2014 :: Server Level Trigger To Log Activity And Rollback After Logging Information

Sep 8, 2015

I use following trigger to stop user "smith" if he try to connect through SSMS to My Server:

create TRIGGER [trg_connection_MyServer]
ON ALL SERVER WITH EXECUTE AS 'Smith'
FOR LOGON
AS
BEGIN
IF ORIGINAL_LOGIN()= 'Smith'
begin
if exists (SELECT 1 FROM sys.dm_exec_sessions
WHERE (program_name like 'Microsoft SQL Server%' and original_login_name = 'Smith') )
ROLLBACK;
end

I want to log this information or send emal incase, this user try to connect through SSMS, so that I can catch it. How can I do this, if I use insert command it rollsback everything and I can't do any activity.

View 8 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved