How Can I Tell What Protocols Are Enabled For The Client?
Jun 21, 2004
If TCP/IP is the only protocol enabled on the General tab of the Client Network Utility, does it mean that other protocols are disabled and will not be used in communicating to SQL Servers on other machines?
In this case, should the registry HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServer ClientSuperSocketNetLib only contain the Tcp entry?
If I have alias setup to use other protocol such as Named Pipes, does it mean that the alias cannot be connected since Named Pipes is not enabled?
Thank you for any help.
View 10 Replies
ADVERTISEMENT
Dec 1, 2003
I have Installed MSDE SP3a (sql2kdesksp3.exe) on a Windows 2003 Web Edition Server.
The security mode is win/sql. I can log in with both Win NT and SQL security localy, from both EM and MSDE manager.
(in the end of the installation, no dialog show, and the agent does not start automaticly, started on restart)
The MSDE is installed from cmd, with no SAPWD but SecurityMode=SQL.
But from another client on the network (same domain), I can´t connect. I get the "SQL Server Does Not Exist or Access Denied" Error Message
I have check the regestry for the tcpip port settings. And its not 0.
I have read some other MSDE related threads, but no luck.
Any hints what to check new, to try to solve this problem ?
peace.
View 3 Replies
View Related
May 21, 2001
Hello,
I need to find out what protocols are used by our client to connect to the SQL Server ?
And is there a way through which we can say that the client are using these protocols, from the Enterprise Manager ?
One more question i have is, I have a SQL server Installation at home on Win98. Why can't i rename the Server Name. I tried using the Sp sp_Dropserver,sp_addserver.
Any help would be of great help.
Thanks,
Shiva
View 2 Replies
View Related
Mar 8, 2007
My ASP website is located on one server & the MS SQL 2000 which is located on a separate physical server behind a separate firewall.
My question is related to Application Communication. I want to know how do the Servers exchange data with one another: which (logical connections to use, which protocols to use)?
View 5 Replies
View Related
Sep 9, 2004
Hi Folks ,
Got one for you .....
By default what ports and protocols do the following sql tools use....?
Enterprise Manager
SQL Query Analyser
SQL Profiler
And if anybody knows :
Performance Monitor
Mapping drives
Event Viewer
User/Server Manager
Any help would be greatly appreciated .....
View 1 Replies
View Related
Oct 9, 2007
I am having a problem with one of the PC's That remotely connects to my server.
When you go to connection properties (under Connect to server in the Management studio) on the users machine there are no options under Network Protocol only the <default> option.
All the rest of our PC's have the option of choosing TCP/IP , named pipe etc etc..
This computer is not able to connect to the server remotely however it can/does when it is on the network.
I figure its because it is attempting to connect over named pipe rather than TCP/IP but i cannot change this in the connection options as it is missing.
And as far as i know on the server i have the default set to TCP/IP but I am really unsure of this.
If anyone can help me out with this i would greatly appreciate it.
View 7 Replies
View Related
Jun 16, 2007
SQL Server Configuraton Manager,
Protocols for sqlexpress,
TCP/IP
When I initially installed SQL Server 2005 Express, it automatically picked up all the IP addresses (60 of them) I had on the server, and filled them in under TCP/IP - IP adresses Tab.
I recently took those IPs off the server and replaced them with 30 new IP addresses. Is there a way to have SQL Server 2005 Express read the Network configuration on the server and take the old IPs off the TCP/IP - IP addresses tab and put the new one's there?
Thanks,
Bill
View 3 Replies
View Related
Apr 16, 2008
Hi,
I have successfully built a project and now want to deploy it for use, however I am getting the following error message:
Error 2 System.Web.Services.Protocols.SoapException: There was an exception running the extensions specified in the config file. ---> System.Web.HttpException: Maximum request length exceeded. at System.Web.HttpRequest.GetEntireRawContent() at System.Web.HttpRequest.get_InputStream() at System.Web.Services.Protocols.SoapServerProtocol.Initialize() --- End of inner exception stack trace --- at System.Web.Services.Protocols.SoapServerProtocol.Initialize() at System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type, HttpContext context, HttpRequest request, HttpResponse response, Boolean& abortProcessing) d:infra srss reportinginfrainfraInfra Enterprise.smdl 0 0
Any ideas on what is wrong?
Thanks!
View 7 Replies
View Related
May 12, 2006
I am running VS Team Suite, and did a fresh installation of SQL Server 2005.
When I try to deploy the sample reports, build was successful.
However, when I try to deploy it, I got the following error:
System.Web.Services.Protocols.SoapException: Server was unable to process request, ---> System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetWebConfigAuthenticationAttribute(String attrName) at
Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetAuthenticationType() at
Microsoft.ReportingServices.Diagnostics.WebConfigUtil.get_UsingWindowsAuth() at
Microsoft.ReportingServices.WebServer.GlobalImpersonateClient() at
Microsoft.ReportingServices.WebServer.ReportingService2005.ctor() -- End of inner exception stack trace.
Anyone encountered a similar error?
Thanxs.
View 4 Replies
View Related
Apr 4, 2007
I am trying to set up SQL Server 2005 to use a test certificate from Thawte for SSL encryption. I have installed the certificate in the local computer, current user and service account's personal certificates folders. I have also installed the root certificate in the Trusted Root Certification Authorities folders of each. All this was done using MMC.
However, when I go to tell SQL Server to use the certificate, no certificates show up in the drop down box. I am using SQL Server Configuration Manager and doing the right-clickPropertiesCertificate steps shown in multiple KB and forum articles.
I have also checked the registry entry at HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerMSSQL.1MSSQLServerSuperSocketNetLibCertificate. It is blank, which tells me SQL Server should be looking in the certificate store.
If I simply set the ForceEncryption flag, SQL Server starts up OK and generates a self-signed certificate. Using that, the session does get encrypted. However, I need to use a third party certificate.
I have hit a brick wall and am at a loss. Any help would be greatly appreciated.
View 10 Replies
View Related
May 21, 2015
I'm having issues with my sql server 2014 express configuration manager. I need to change protocols under Sql Server Network Configuration but there is nothing, no protocol listed, its empty.
View 3 Replies
View Related
May 28, 2001
We have 15 clients running our applicaton
14 of then conected to SQL server using TCP/IP and it runs fine
1 of 15 when connected using TCP/IP produce "..Time out error "
but runs fine when swiched from TCP/IP to Named pipes
1.What area should we look to correct problem with Time out using TCP/IP ?
2. Where to get information about using TCP/IP via Named pipes ?
View 1 Replies
View Related
May 10, 2006
Product: Microsoft SQL Server 2005 -- Error 29515. SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Encryption not supported on the client. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
View 78 Replies
View Related
May 2, 2006
On Windows XP systems I get the following issue when trying to browse the MSDB folder in SSIS
Client unable to establish connection
Encryption not supported on SQL Server. (Microsoft SQL Native Client)
I have noticed another post where several others have noticed the same issue. It appears to only occur on Windows XP installations. Is there a workaround or fix for this?
View 2 Replies
View Related
Nov 1, 2006
Hi,
I have SQL2000 installed as the default instance, and now I'm trying to install SQL 2005 standard edition as a named instance.
I receive this error :
SQL Server could not connect to database service for server configuration.. [SQL Native client] Encryption not supported on the client. However I'm able to install client tools
The setup works fine on other box with the same config : SQL 2000/Windows XP, is there any work around for this issue ?
In my SQL 2000 client network utilty "Force proctocol encryption " is desabled and did not find the setting for SQL 2005 !
Thank you
View 1 Replies
View Related
Jul 23, 2005
Hello,Is it necessary to upgrade the Client Connectivity Tools on all clientmachines after the SQL Server database server is upgraded from Version7.0 to 2000?Thank you in advance!Eddy
View 1 Replies
View Related
Nov 4, 2005
Can anyone tell me what this means and how to fix it? I created a stored procedure in VS2005 and did a build. When I went to SQL Server there was the stored procedure but when I run it I get the error....
View 24 Replies
View Related
Jun 11, 2007
Hi All,
When i run the command,
use master
go
sp_configure 'awe enabled',1
go
reconfigure
go
I got the output,
name : awe enabled
minimum: 0
Maximum: 1
config_value: 0
run_value: 0
From the value of config_value ,it mean that the "awe" is not enabled.
But, when we see the System Configuration:
OS --- Win 2003 Standard sp1
Sql server 2005 sp1 ( I have only one instance )
System configuration = 3.83 GB of RAM
The total is 3.83GB of RAM, but When i right click the sql server
instance , select 'Properties' and then on the 'General' tab , i
see 'Memory' assigned to that instance as = 3927 (MB)
Does this mean that, someone already has enabled AWE option. That's
the reason its showing memory = 3927 MB. (or) i have to enable it
externally.
Can someone reply as soon as possible plz.
Thanks.
View 4 Replies
View Related
Dec 3, 2007
now i have enabled awe in sqlserver 2005.And i set the LOCK PAGE IN MEMORY in group policy.but while i see the sqlserver agent log ,i find that the log shows 4 processor(s) and 4096 MB RAM detected,in fact my server have 8GB RAM.so anyone can help me ?Thanks
i have see the sqlserver log ,and find awe enabled
View 6 Replies
View Related
Mar 3, 2007
Hi,
While using Sql Native Client ,VB Application giving error
"Transcation Cannot Start because more than one ODBC connection is in use"
But when useing SqlServer client then work perfectly ok.
Please guide where to use Sql Native Client.
Thanks
Rizwan
View 1 Replies
View Related
Apr 23, 2008
I have tried this on several different operating systems (VISTA and XP ) and several versions of SQL NATIVE CLIENT including 2005.90.3042.0
I have a 64 bit "SQL NATIVE CLIENT" connection that fails. The exact same connection and code succeeds on 32 bit.
My customer and I prepend "oledb:" to the connection string and it starts working.
FAILS on 64 bit:
Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Wrigley_Test;Data Source=MONGO;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=RIPTIDE;Use Encryption for Data=False;Tag with column collation when possible=False;MARS Connection=False;DataTypeCompatibility=0;Trust Server Certificate=False
WORKS
oledb:Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Wrigley_Test;Data Source=MONGO;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=RIPTIDE;Use Encryption for Data=False;Tag with column collation when possible=False;MARS Connection=False;DataTypeCompatibility=0;Trust Server Certificate=False
I debugged my code to the point that I know it is happening when I call CreateAccessor for my SQL statement.
m_hr=m_pIAccessor->CreateAccessor(DBACCESSOR_ROWDATA, GetCols(), (m_pDBBinds+IsBookmarked()), 0, &m_hAccessor, NULL);
Error:
Microsoft SQL Native Client: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
Does anyone have any suggestions?
View 6 Replies
View Related
Feb 15, 2002
I've looked in several books in addition to the online SQL Server documentation, and I can't find a way to determine whether or not a trigger is enabled or disabled. I know how to enable/disable, I just can't figure out the current status of the trigger. It's not returned in sp_help or sp_helptrigger, and there's no indication in Enterprise Manager of a trigger's status. Does anyone out there know how to do this?
View 1 Replies
View Related
Feb 3, 1999
I'm tryng to restore a single table (12000 records) from a database backup, but during the restore process I receive the message :
DBProcess is dead or not enabled.
If I try to restore a smaller table (9000 record) there is no problem.
Any idea?
Thanks!
View 1 Replies
View Related
Feb 15, 2008
I execute the following:
-- Turn on advanced options
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
-- turn on clr
sp_configure 'clr enabled', 1
GO
RECONFIGURE;
GO
and get this error:
Msg 15123, Level 16, State 1, Procedure sp_configure, Line 78
The configuration option 'clr enabled' does not exist, or it may be an advanced option.
When I run surface area config, I select Configuration for Features, but under MSSQLSERVER, I do not see the entry for Database Engine that should have the CLR Integration under it.
Any suggestions? Thanks in advance.
View 5 Replies
View Related
Jul 24, 2000
Hi,
I'm using SQL Server 7.0. I'd like to know if there is anywhere in the information schema or system tables where I can tell that a constraint has been flagged as 'enable constraint for INSERT AND UPDATE' or not.
Thanks in advance,
Darrin
View 1 Replies
View Related
Jan 6, 2005
Hi,
While reading (I have come across what seems to be maybe a powerful and useful feature) available in MSAS and thus this related question:
Can someone briefly explain the use of this feature and how it can come in handy.
So far I have skimmed through BOL and it says that "Only parent-child dimensions support this dimension characteristic" i.e. Write-enabled feature.
Thanks.
View 2 Replies
View Related
Apr 25, 2007
Hi,
I tried to run the following script from SQL2005 server A (publisher) from Database 'TestDB' to SQL2005 server B
(subscriber) database 'TestDB'
-------------------------------------------
exec sp_addsubscription @publication = N'publish_TestDB_FromCA', @subscriber = N'subscriberTest', @destination_db = N'TestDB', @subscription_type = N'Push', @sync_type = N'automatic', @article = N'all',
@update_mode = N'read only', @subscriber_type = 0
with following error:
Msg 14013, Level 16, State 1, Procedure sp_MSrepl_addsubscription, Line 252
This database is not enabled for publication.
Any idea?
Thanks
David
View 14 Replies
View Related
Aug 18, 1998
Hello,
Can anyone help me how to solve this problem ?
I had message "DBPROCESS is dead or not enabled" from my Server SQL v.4.2.1b.
I hope anyone want to help me.
Regards,
Susan
View 3 Replies
View Related
Jul 21, 2004
I have a VB6 application from which I want to create and schedule a jobs. The individual jobs should run once and be deleted when succesfully finished. Almost everything works fine. But enabling the jobschedule won't work. In the sp below I set the @enabled parameter of sp_add_jobschedule to 1 (is also default) which should indicate that the schedule is enabled. How to fix this, or what I am doing wrong? I tried to place an execute sp_update_jobschedule at the end of the sp, but no effect at all.
CREATE PROCEDURE mis_CreateCustomJob (
@strUserName varchar(50),
@strDateTimeStamp varchar(14),
@strJobType varchar(10),
@intDate int,
@intTime int
)
AS
BEGIN TRANSACTION
DECLARE @JobID BINARY(16)
DECLARE @JobName VARCHAR(67)
DECLARE @ReturnCode INT
SELECT @JobName = 'jb_' + @strUserName + @strDateTimeStamp
SELECT @ReturnCode = 0
BEGIN
-- Add the job
DECLARE @strDescription VARCHAR(100)
SELECT @strDescription = 'Job aangemaakt met MUC door ' + @strUserName
EXECUTE @ReturnCode = msdb.dbo.sp_add_job
@job_id = @JobID OUTPUT ,
@job_name = @JobName,
@owner_login_name = N'Admin',
@description = @strDescription,
@category_name = N'[Uncategorized (Local)]',
@enabled = 1,
@notify_level_email = 0,
@notify_level_page = 0,
@notify_level_netsend = 0,
@notify_level_eventlog = 2,
@delete_level= 1
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
-- Add the job steps
DECLARE @strCommand varchar(100)
SELECT @strCommand = 'SET ANSI_NULLS ON' + char(13) + 'SET ANSI_WARNINGS ON' + char(13) + 'go ' + char(13) + char(13) + 'exec mis_JobTest'
EXECUTE @ReturnCode = msdb.dbo.sp_add_jobstep
@job_id = @JobID,
@step_id = 1,
@step_name = N'Upload Contracttabellen',
@command = @strCommand,
@database_name = N'mis',
@server = N'',
@database_user_name = N'',
@subsystem = N'TSQL',
@cmdexec_success_code = 0,
@flags = 0,
@retry_attempts = 0,
@retry_interval = 1,
@output_file_name = N'',
@on_success_step_id = 0,
@on_success_action = 1,
@on_fail_step_id = 0,
@on_fail_action = 2
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
EXECUTE @ReturnCode = msdb.dbo.sp_update_job @job_id = @JobID, @start_step_id = 1
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
-- Add the job schedules
EXECUTE @ReturnCode = msdb.dbo.sp_add_jobschedule
@job_id = @JobID,
@name = N'HandmatigeUpload',
@enabled = 1,
@freq_type = 1,
@active_start_date = @intDate,
@active_start_time = @intTime
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
-- Add the Target Servers
EXECUTE @ReturnCode = msdb.dbo.sp_add_jobserver
@job_id = @JobID,
@server_name = N'(local)'
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback
END
COMMIT TRANSACTION
GOTO EndSave
QuitWithRollback:
IF (@@TRANCOUNT > 0) ROLLBACK TRANSACTION
EndSave:
GO
View 3 Replies
View Related
Jan 16, 2007
Just curious to hear if anyone else has experiences this or knows a reason
why it maybe should be this way...
I have some jobs that are disabled accourding to the Job Activity Monitor view in Mgmt Studio. However, if I open the schedules details, this view says Enabled. Can a schedule be enabled for a job, even if the job in itself is
disabled maybe?
But, I can't see any enable/disable flag in the sysjobschedules table,
only in sysjobs.
View 2 Replies
View Related
May 28, 2008
We are running application on Ms SQL Server connecting to PowerBuilder 7.0.3, using MSS Microsoft SQL Server 6.X driver.
We have recently migrated the SQL Server from 2000 to 2005 SP2, in which databases are still at compatability level 80.
The application runs perfectly for one week, but later we received some occassional reports from users that database connection breaks after a
certain idle period. Below are the errors, usually error 1 appears before error 2.
Error 1
A database error has occured.
Database error code: 10025
Database error message:
Select error: Possible network error: Write to SQL Server Failed. General network error. Check your documentation.
Error 2
A database error has occured.
Database error code: 10005
Database error message:
Select error: DBPROCESS is dead or not enabled.
We couldn't find any related errors in the SQL Server log. Does anyone has the idea of what's wrong or how to trace the connection brokerage?
View 3 Replies
View Related
May 2, 2008
Is it possible to check if xp_cmdshell is enabled on a server or not? (Using T-SQL*)
How would you perform this check?
View 7 Replies
View Related
Mar 13, 2008
I am trying to mirror a database and I keep getting the error Msg 1469 saying that "Database mirroring cannot be enabled because the database is an auto close database on one of the partners. Well.. the database properties is saying "false" under auto-close. What else could be wrong?
View 12 Replies
View Related
